sql server does not allow to remote connection.

Question

chandiusjp 0 Newbie Poster

15 Years Ago

Hi All,

i worked hard with following error from two weeks. when i am connecting to my sql database from client machine using vb.net following error occured. its worked for local machine.

"an error has occured while connecting 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:named pipes provider,error 40-could not open a connection to SQL server)"

please help me.

Thanks in Advance!

vb.net

8 Contributors
13 Replies
253 Views
5 Days Discussion Span
Latest Post 15 Years Ago Latest Post by samir_ibrahim

Stevoni 14 Junior Poster in Training

15 Years Ago

Have you tried this from MSDN?

kvprajapati 1,826 Posting Genius

15 Years Ago

>sql server does not allow to remote connection.
Post your connection string code.

str="Data Source=.\sqlexpress;Initial Catalog=dbfirst;Integrated Security=True"
'or
str="Data Source=.\sqlexpress;Initial Catalog=dbfirst;User id=sa;Password=sa"

Read about MS-Sql server authentication - http://msdn.microsoft.com/en-us/library/aa905171(SQL.80).aspx

samir_ibrahim 58 Junior Poster

15 Years Ago

What do you mean by "its worked for local machine."?
You installed Sql server locally on a macine and your code works? how the client suppose to connect (also locally or remotely)?

Check if you change the password for the administrator.

kvprajapati commented: Good point. +11

murid 11 Light Poster

15 Years Ago

have U try to shutdown your firewall ??
sometime firewall block any connection without warning..

http://blog.sqlauthority.com/2008/08/09/sql-server-fix-error-1326-cannot-connect-to-database-server-error-40-could-not-open-a-connection-to-sql-server/

i don't know it is can help U or not..

kvprajapati commented: Good suggestion. +11

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

chandiusjp 0 Newbie Poster · Answer 1 · 2009-08-25T13:05:04+00:00

thanks stevon,

i tried with this. but it doesn't worked. can you please give a another solution.

chandiusjp 0 Newbie Poster · Answer 2 · 2009-08-26T22:27:14+00:00

thanks all,

"its worked for locally" mean i installed sql to my server and program worked for that machine. but i cant run program from other machine which connected to network(TCp/IP).at that time error message displayed.

i can connect to server machine through network normally(using "Ping" command).

please help me.

chandiusjp 0 Newbie Poster · Answer 3 · 2009-08-26T22:30:54+00:00

ConnectionString = "data source=SERVER;initial catalog=dbPayroll;persist security info=False;user id=sa; password=sa"

samir_ibrahim 58 Junior Poster · Answer 4 · 2009-08-27T22:19:52+00:00

It could be a firewall problem as murid pointed out.
- What is the OS that the MSSQL is install on?

Try to:
- from any client pc, Go to control panel >> administrator tool >> Data Source (ODBC) and try to create a connection from there.

Does it succeed?

mania_comp -2 Light Poster · Answer 5 · 2009-08-28T03:04:51+00:00

You need to have an account with full admin permissions to login form client PC
So create a account with full permission on server and use that on client machine.
Also make sure password for account is not blank
Moreover , you must do settings to allow sql server to do remote connection
Steps :
1) Enable TCP/IP in remote connections from Surface Area Configration
2) Start Browser Service
3) Add sqlserver.exe to firewall exception
For Details you can GOOGLE "Allow remote connections in sql server"
Best of luck

sknake 1,622 Senior Poster Featured Poster · Answer 6 · 2009-08-28T05:46:39+00:00

Shut the service down, grab your .mdf and .ldf files, and reinstall the service properly if you can't figure out the surface area configuration:

setup.exe /qb ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,Client_Components,Connectivity,SQL_SSMSEE INSTANCENAME=@@InstanceName@@ SAVESYSDB=1 SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 AGTAUTOSTART=1 SECURITYMODE=SQL SAPWD=@@Password@@ DISABLENETWORKPROTOCOLS=0 ERRORREPORTING=1 SQMREPORTING=0 ADDUSERASADMIN=1 INSTALLSQLDIR="%ProgramFiles%\Microsoft SQL Server\"

cgeier 187 Junior Poster · Answer 7 · 2009-08-29T05:38:57+00:00

See the following post: http://www.daniweb.com/forums/post933374.html#post933374

chandiusjp 0 Newbie Poster · Answer 8 · 2009-08-29T10:45:08+00:00

It could be a firewall problem as murid pointed out.
- What is the OS that the MSSQL is install on?
Try to:
- from any client pc, Go to control panel >> administrator tool >> Data Source (ODBC) and try to create a connection from there.
Does it succeed?

can not create odbc connection as well.what's wrong?

samir_ibrahim 58 Junior Poster · Answer 9 · 2009-08-29T19:09:29+00:00

can not create odbc connection as well.what's wrong?

You had mentioned before that you have a MSSQL server, what is the OS of that server? Win Server 2000 or 2003 or 2008?

When you tried to create the ODBC, in the second page where it ask you "How should sql Server verify ....." there is a button "Client Configuration" click on it and check what it gives you, try to change the server name to IP address.