[Bent al-Yemen]

Hello,i have installed sqlserver for the first time successfully with out any problems. By mistake i restored my system to a point before installing sqlserver. And we i tried to reinstall it i could not, many mistakes happened during installing process. So I uninstalled all component of VS and SQL server and installed them again. This time it worked, but at the middle of sqlserver intsalling,i changed the instance name to "SQLEXPRESS5", because it wouldn't work with changing the name, it gives my an error.

After i finished installing sqlserve, i couldn't add a database to my project. It gives me the following error:


could any one help me pleeeaase, i'm so tired of that.

Thanx

This post has been edited by Bent al-Yemen: 23 April 2010 - 06:46 AM

[Jayman]

Did you change the instance name to SQLEXPRESS5 in your connection string after you reinstalled it?

Have you verified that the Sql Server service is running?

-> Right click My Computer and select Manage. Expand Services and Applications and the select Services.

Do you see Sql Server (SQLEXPRESS5) and Sql Server Browser? They should both be started.

[Bent al-Yemen]

Someone advised me to uninstall sqlserver again and install it with the default name. i did so . And thanks to Allah , i didn't have to uninstall VS too. I just uninstalled sqlserver , but i'm still have the same error.
i'm stuck now, when i did what told me Mr.Jayman , i found SQLEXPRESS5 . But i could not make it start.

Any help, and thank you so much Mr.Jayman .

[Jayman]

Go to Start -> All Programs -> Microsoft Sql Server -> Configuration Tools -> Sql Server Configuration Manager.

You should see something similar to the following.


Right click in the right panel on Sql Server and select Start from the context menu. Do you get any error messages?

If possible can you post a screen shot of what you have in Configuration Manager.

[Bent al-Yemen]

Thank you so much Mr.Jayman for you generosity.
when i tried to start the first item


i get this error

But the second item worked


Actually now i'm having strange issue, i discovered that i can make a connection with my pc'name only. So i don't write "sqlexpress/pc'name" just pc'name. But i can't add a database "from add an item".

kind of, this very good. But i still want to add a database from "add an item".

[Bent al-Yemen]

Pleeaase somebody give me a hand. I'm really tired with this issue.

Now when i try to create a new connection i get this error:

[PsychoCoder]

Read through this, there are several solutions to that error message found there

[Bent al-Yemen]

i'm very annoying girl. I know, but i don't know whom i should ask.i'm doing my best searching in the net.But i can't find solution to problems.I swear i have done everything before this time with out any problem.



This is the code i'm trying to debug:

string connectionString = "Data Source=localhost; Initial Catalog=Northwind;" +
"Integrated Security=SSPI";
        SqlConnection con = new SqlConnection(connectionString);
        try
        {
            // Try to open the connection.
            con.Open();
            lblInfo.Text = "<b>Server Version:</b> " + con.ServerVersion;
            lblInfo.Text += "<br /><b>Connection Is:</b> " + con.State.ToString();
        }
        catch (Exception err)
        {
            // Handle an error by displaying the information.
            lblInfo.Text = "Error reading the database. " + err.Message;
        }
        finally
        {
            // Either way, make sure the connection is properly closed.
            // Even if the connection wasn't opened successfully,
            // calling Close() won't cause an error.
            con.Close();
            lblInfo.Text += "<br /><b>Now Connection Is:</b> " +
            con.State.ToString();
        }

i have put this code in another topic, but with different errors. So i'm really really sorry.

[PsychoCoder]

• That ASP.Net has been properly registered in your deployment box.
  
  To verify this run aspnet_regiis -i from a command window in
  C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
  
• Make sure your configured ASP.NET account has the proper file permissions see this
  
• If using IIS 6.0 read this

[Bent al-Yemen]

Thanx Mr PsychoCoder , i'll try that , though i didn't understand some points. I guess i'm going to uninstall VS and sqlserver again, this may work since it worked at the beginning. Thank you so much.

[Bent al-Yemen]

congratulaaaaate meeeee

finally, it worked. I just wanted to thank you for you help, and please if any one faces similar problem. Just tell me , cuz i became an expert after this long long experience loooool.

And i have very very simple problem, my database explorer and my toolbox are floating( i have to move them from side to side to see my code). I don't know how to make them stuck again.

Thanx