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
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