Reinstall problems. Finding server.

[willydude]

Over the weekend my PC died and I had to reinstall everything. When re-installing SQL Server 2005 Express and Management Studio, I have encountered some problems. I do not recall having any major issues when I installed it over a year ago. I did save a lot of my work on a flash drive. Hopefully I saved what I will soon be needing.

I have a folder with Microsoft SQL Server. It has sub folders with names such as 80 and 90 and more sub folders named COM, Tools, Binn, Eula, etc.

With Mgmnt Studio, how do I find and connect with SQL Server? What is the server name? When I select “Browse for more”, nothing appears. It seems that everything I try wants the server name, for which I do not know.

I found the following on the web “select @@servername” , but it assumes that you have a connection to a server and are looking for another server (I believe). I don’t have the name of my host (?) server.

One current message is “The installation package for Microsoft SQL Native Client cannot be found. Try installing again using ‘sqlncli.msi.”

I found some info on the MS site and it seems to me that I do not need the NC. The MS site says “For new applications, if you're using a managed programming language such as Microsoft Visual C# .NET or Visual Basic .NET, and you need to access the new features of SQL Server 2005, you should use the .NET Framework Data Provider for SQL Server, which is part of the .NET Framework for Visual Studio 2005. This will give you the most robust data access component for working with SQL Server 2005.”

It also looks like Data Services failed to load.

Thanks a ton for any and all help.

Bill

 

[johnc83]

Hi Bill.

I am by no means an expert on this but here is my configuration that works..

Server name = 128.128.128.9\SQLEXPRESS
Authentication = SQL Server Authentication
Login = sa
Password = mypassword

I have had trouble in the past with the server name but my configuration above points to the IP address of our server followed by the name of the 'SQL INSTANCE' - I think the default is SQLEXPRESS.

Hope this helps

John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express

 

[willydude]

John,

Thanks for the reply. I came to the conclusion that I did not actually have the program installed. I do have SSManagement installed, but not the SQL Server itself.

After installing, reinstalling and maxing out with frustration, I am at a loss.

I have gone through the whole process five or six times.

I received a success message during installation about the DB services and Client Components. But it always ended with a message that SQL Server Express cannot be installed on your computer.

I have done the download of 36 meg I believe and the one with Advanced Services. Same situation in both.

As mentioned before, I had it running until my PC crashed and have now had to reinstall.

Any suggestions?

Thanks,

Bill

 

[johnc83]

Unfortunately, if it says it cannot be installed on your PC then I don't have any advice. I have SQL Express 2005 installed on 2 servers at work no problem but when I tried to install it on my laptop at home it said I couldn't do it because my hardware (think RAM was too low) wasn't up to scratch, but obviously sounds like this isn't your problem seeing as you had it installed before.

Can you post the exact error message and maybe someone knows what to do from there.

Sorry I can't be more help, I am still a newbie!

John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express

 

[willydude]

John,

I got it to work. After doing some searching and reading of posts on different sites, I found that:

1)I needed to remove the current Native Client program.
2)D/L and run the file ‘sqlncli.msi' from MS. It saved itself to the correct directory.
3)Re-run the SQL Express setup.

I lost all my tables in the DB I was working on, but I do have the sprocs, so I'll make it.

Thanks for the help.

Bill

 

[johnc83]

Glad to hear you got it sorted Bill,

John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express