Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connection string getting Server does not exist or access denied Expand / Collapse
Author
Message
Posted Wednesday, February 19, 2014 9:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 20, 2014 9:12 AM
Points: 5, Visits: 39
I am running Localhost on windows 7, with sqlexpress 2005, i keep getting Server does not exist or access denied error with this connection string:
Provider=SQLOLEDB;Data Source=.\MyMACHINE\SQLEXPRESS;Initial Catalog=mydbase;Integrated Security=SSPI;

when I switch datasource to (local) , same thing

running with Windows auth

??
Z
Post #1543319
Posted Wednesday, February 19, 2014 10:12 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 13,103, Visits: 11,933
http://www.connectionstrings.com/

They have details about every possible connection string possibility you can come up with.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1543325
Posted Thursday, February 20, 2014 7:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:43 AM
Points: 6,178, Visits: 13,323
znetznet (2/19/2014)
I am running Localhost on windows 7, with sqlexpress 2005, i keep getting Server does not exist or access denied error with this connection string:
Provider=SQLOLEDB;Data Source=.\MyMACHINE\SQLEXPRESS;Initial Catalog=mydbase;Integrated Security=SSPI;

when I switch datasource to (local) , same thing

running with Windows auth

??
Z

You should be using

Provider=SQLOLEDB;Data Source=MyMACHINE\SQLEXPRESS;Initial Catalog=mydbase;Integrated Security=SSPI;




-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1543483
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse