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

Connecting to Database ERROR Expand / Collapse
Author
Message
Posted Tuesday, November 24, 2009 4:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 24, 2009 7:59 AM
Points: 3, Visits: 5
Hi Friends,

I am working on VS2008 with database as SQL Server 2005 and then I try to run any forms I am getting the below error message, can someone help me please.

"SQL Error 87 : 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: SQL Network Interfaces, error: 25 - Connection string is not valid)"
Post #823759
Posted Tuesday, November 24, 2009 5:40 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,646, Visits: 1,947
Details are missing..

In VS2008, are you creating forms or debugging someone's created forms?

Where is the SQL 2005, is it in the same domain,then how are you connecting to it using SQL Login or WIndows Authentication?

Were you able to connect to the SQL 2005 server earlier?

Cannot guess all these question, reply with answers and will go one step at a time...



Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #823795
Posted Tuesday, November 24, 2009 5:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 24, 2009 7:59 AM
Points: 3, Visits: 5
Hello,

Thank you for the the reply, here are the details:

In VS2008, are you creating forms or debugging someone's created forms?
-- I am creating the new forms and saving the data to the SQL Server 2005

Where is the SQL 2005, is it in the same domain,then how are you connecting to it using SQL Login or WIndows Authentication?
-- Using Windows Authentication mode

Were you able to connect to the SQL 2005 server earlier?
-- No not able to connect at all
Post #823804
Posted Tuesday, November 24, 2009 7:56 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,646, Visits: 1,947
Since you were never able to connect to SQL Server from VS2008, let me know what are the steps you are performing to create a new connection?


Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #823896
Posted Tuesday, November 24, 2009 8:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 24, 2009 7:59 AM
Points: 3, Visits: 5
Hello,

The issue has been resolved, thanks
Post #823903
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse