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

error 08004 Expand / Collapse
Author
Message
Posted Tuesday, December 4, 2007 5:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 12, 2007 5:11 PM
Points: 2, Visits: 1
I have recently installed sqlexpress 2005 on a xp machine i have activated all tcp/ip settings needed aswell as that all services are running that i know of but i still have an error popping up in a virtual machine that i have created trying to connect to the sqlexpress server the error reads connection failed SQLSTATE '08004'
SQL Server Error: 4060
server rejected the connection; connection to the selected database has been denied

can any one suggest any other ways to get this sql client communicating with the sql server!!

its ripping my head apart maybe because im just a begginer

cheers!
Post #429210
Posted Monday, December 10, 2007 11:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 29, 2012 12:37 PM
Points: 16, Visits: 93
Check to make sure the login that you are connecting to the server with has connect permissions in the database you are connecting to. If you are not specifying a database, make sure it has connect permissions for its default database.
Post #431441
Posted Wednesday, December 12, 2007 5:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 12, 2007 5:11 PM
Points: 2, Visits: 1
Yes well i have managed to get the client connecting to the server the actual program has been logging and creating its own username in the SQL express database without my knowing that the 26 character hexadecimal username was created at all so i have figured that one out now i tried to change the username to admin or something and i had to tick the sysadmin check box aswell the database in the Security tab and everything is working fine thanks for the reply
Post #432616
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse