problem occurred while establishing a connection to SQL Server
-
hi every body im having a big problem. icant connect to my data base. i have this error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) i dont know what to do please help me
-
hi every body im having a big problem. icant connect to my data base. i have this error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) i dont know what to do please help me
Is Remote Connection enabled for your SQL server instance? Goto Configuration Tools >> SQL SErver Surface Area Configuration >> Surface area configuration for services and connections Enable the remote connection by selecting local and remote connection (using both TCP/IP and named pipes) HTH
Coding C# ExciteTemplate
-
Is Remote Connection enabled for your SQL server instance? Goto Configuration Tools >> SQL SErver Surface Area Configuration >> Surface area configuration for services and connections Enable the remote connection by selecting local and remote connection (using both TCP/IP and named pipes) HTH
Coding C# ExciteTemplate
thanks for your reply but it didnt work i try it many times before :sigh: do u have any thing else?
-
thanks for your reply but it didnt work i try it many times before :sigh: do u have any thing else?
Are you able to connect with SQL Server Management Studio?
-
Are you able to connect with SQL Server Management Studio?
yes
-
yes
What type of application did you connect with SQL Server? ASP.NET or Windows application? What type of authentication are you using to connect?
-
yes
Is your connection string correct? Post it
Coding C# ExciteTemplate
-
What type of application did you connect with SQL Server? ASP.NET or Windows application? What type of authentication are you using to connect?
Asp.net and im using mixed mode my code string m = "Data Source=./SQLEXPRESS;AttachDbFilename=C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Data/TestData.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; SqlConnection mycon = new SqlConnection(m); mycon.open();
-
Asp.net and im using mixed mode my code string m = "Data Source=./SQLEXPRESS;AttachDbFilename=C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Data/TestData.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; SqlConnection mycon = new SqlConnection(m); mycon.open();
http://www.connectionstrings.com/ This shall help you!!
Coding C# ExciteTemplate
-
Is your connection string correct? Post it
Coding C# ExciteTemplate
what is wrong with my connecting string????
-
Asp.net and im using mixed mode my code string m = "Data Source=./SQLEXPRESS;AttachDbFilename=C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Data/TestData.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; SqlConnection mycon = new SqlConnection(m); mycon.open();
You are missing DATABASE name in connection string.
Coding C# ExciteTemplate
-
what is wrong with my connecting string????
Check the above reply.
Coding C# ExciteTemplate
-
Check the above reply.
Coding C# ExciteTemplate
i add database name but it give me the same result :sigh: what is ment by Verify that the instance name is correct ?????
-
i add database name but it give me the same result :sigh: what is ment by Verify that the instance name is correct ?????
Data Source=./SQLEXPRESS ./SQLEXPRESS This is instance name. Check in your management studio if this is correct. HTH
Coding C# ExciteTemplate
-
Asp.net and im using mixed mode my code string m = "Data Source=./SQLEXPRESS;AttachDbFilename=C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Data/TestData.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; SqlConnection mycon = new SqlConnection(m); mycon.open();
So you are using Windows Authentication. ASP.NET application will be running under ASPNET account if you open your site from local IIS. Therefore the ASPNET may not have access to the database. Try to use SQL authentication. Also the database path should look like C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\TestData.mdf. I am not sure ADO.NET will accept / in a path specification.
-
hi every body im having a big problem. icant connect to my data base. i have this error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) i dont know what to do please help me
just do the following steps goto StartMenu ---->SqlServer----->Configuration Tools-------->SQL Server Configuration Manager and check in NAMED PIPES protocol is enabled or not :)
Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it
-
just do the following steps goto StartMenu ---->SqlServer----->Configuration Tools-------->SQL Server Configuration Manager and check in NAMED PIPES protocol is enabled or not :)
Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it
i enabled it and it suggest to restart sql what to do next????
-
i enabled it and it suggest to restart sql what to do next????
Restart your pc or restart the SQL services. Control Panel > Administrative Tools > Services
Coding C# ExciteTemplate
-
Restart your pc or restart the SQL services. Control Panel > Administrative Tools > Services
Coding C# ExciteTemplate
ops it didnt work ido all thing but the same problem occured
-
ops it didnt work ido all thing but the same problem occured
Have you enabled Client Protocol > Named Pipes ?
Coding C# ExciteTemplate