Cannot open database on local server

Cannot open database on local server

• Mamatha

  Hi,

  I saw you post and it seem that yu have solved the problem.

  I am also newbie to SQL, and have the same problem of accesing SQL database.

  Can you details how you did it for pubs and northwind on the SQL server

  many thanks in advanced.

  dktran

  
  
  

• Rose Say

  It looks like the user in the machine/domain MLHPR called ASPNET is the one trying to access the database. I'll bet there's no login for that user in the system.

  The first thing to do is try and see if you can connect at all - on the server where SQL Server lives, type this at a Windows command prompt:

  osql -E -d pubs -Q "SELECT 'I got in.'"

  If you see the words "I got in" on the screen, then SQL Server is up and running. If not, either SQL isn't installed or there is no database called "pubs" on it.

  You can read more about SQL Server security here: http://www.informit.com/guides/content.asp g=sqlserver&seqNum=35&rl=1

  Note: If this answers your question, make sure you mark it "answered" so that others can find it!

  Buck Woody
  http://www.buckwoody.com

  
  
  

• murph___

  thanks you very much for your response

  ya pubs was not configured to be used with the sql server. i searched for the file and found the file in some folder of sql but not on the sql server. then i worked around in the microsoft .net folder to find the installation file for configuring the databases 'pubs' and 'northwind' on the sql server.

  when i installed the file it worked fine.another reason was that i forgot to add the server to the expection list of the firewall.

  the installation file for databases was in the 'microsoft .net/sdk/v2.0/samples/setup/' folder for using with quickstart samples of the asp .net.

  
  
  
• Cannot open database on local server