I am having a problem adding a new server or going into my previously registered servers.
I was using Sql express and now using the full version of SQL 2005.
When I try to coonect to a server, In the server type I choose Database Engine
Server name I typed in LOCALHOST\SQLEXPRESS, no names show in the
dropdown for server, leave use windows authentication selected. then hit the
advanced button and change the network library to shared memory, hit test
button and get this error:
"An error has occurred while establishing a connection to the server. when
connecting to sql server 2005, this failure may be caused by the fact that
under the default settings sql server does not allow remote connections.
(provider: shared memory provider, error: 36 - the shared memory dll used to
to connect to 2000 was not found)"
any input would be appreciated. thanks.
Are you connecting to the Remote server or a Local server?|||local server|||<connectionStrings><add name="ConnectionString" connectionString="Data Source=.\SQLSERVER;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient" /></connectionStrings>
SQLSERVER is the server Name of your SQL SERVER. Check the name of the server (by default its SQLSERVER)
OR (create a new connection string)
Create a new Page > Put a GridView on it > Click the right Top corner and select the "New data source" > Click "Database" in the step "Choose a Data Type > Click OK > Now when you click the Drop down, probably you will see your Data base name in it.
(you will see the database name with your connection strings when the connection strings in web.config are not valid)
1. If you see the Database name:
Click Next and select any Table from your Database> Click Next again Ok > Click Finish. Now when you open your Configuration File (i.e web.config) you will see a new Connection string with the server Name.
2. If you dont see the Database Name:
Click "New Connection" in the step "Choose your data Connection" > Choose "Microsoft SQL Server" type and click Continue > choose your SQL SERVER Name from the Drop down next to REFRESH button> Attach the DataBase to the server > Now you can create a Connection string to the server.
Happy coding!
|||I cannot register a server in sql server Management Studio
and this is the error i get
New Server Registration
Testing the registered server failed. Verify the server name, login credentials, and database, and then click test again.
Additional Information
=>An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)(Microsoft Sql Server)
|||Hi,
Please check if you have the correct Servername and Instance name of that specific server.
I suggest you create a .UDL file to test the connection with the following steps:
1. Create a normal Text file.
2. Rename it to .udl extension.
3. Double click on that file and a Data Link Properties dialog box will be show.
4. Select the provider and data source, specify username and password, and click the Test Connection button for test.
When I Have Microsoft OLE DB Provider for OLAP Drivers, it returns these options in the data source name
dBASE Files|||Hi,
Are you connecting to a OLAP service(like SQL Server analysis service)? If not, I would suggest you use OLE DB Provider for SQL Server or SQL Native Client instead.
You can choose them from the Provider tab in Data Link Properties dialog box.
No comments:
Post a Comment