November 14, 2014 at 6:32 pm
I have just installed SQL Server Express on a windows 8.1 pro machine and migrated my access db to it.
I have an application written in VB .Net which works perfectly when run on the computer with SQL Server on it. (the app was written to work with both access and sql server)
however, when i go to another computer where i have a mapped drive to the computer with the SQL server on it and i run the application from that mapped drive i get this error:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
My connection string is
Provider=sqloledb;Data Source=ANTEC\SQLEXPRESS;Initial Catalog=CATSSQL;TRUSTED_CONNECTION=Yes;
i know it can be done as it works at other places with the same setup.
i have checked the things like TCP/IP and Name Pipe is enabled. sql server browser is running, windows firewall is set to allow the incoming connections etc.
obviously the server machine is visible to the client as the mapped drive works fine.
any help would be appreciated.
thanks
November 14, 2014 at 7:29 pm
further to this, it isnt a firewall issue. i disabled the firewall and it gave me the same error
November 15, 2014 at 8:55 am
You need to enable remote access.
A few links that can help
http://blog.citrix24.com/configure-sql-express-to-accept-remote-connections/
http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply