Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reinstall problems. Finding server.

Status
Not open for further replies.

willydude

Programmer
Oct 24, 2006
123
US
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
 
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
 
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
 
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
 
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
 
Glad to hear you got it sorted Bill,

John

.NET 2.0, Visual Studio 2005, SQL Server 2005 Express
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top