December 4, 2007 at 5:04 am
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! :w00t:
December 10, 2007 at 11:01 am
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.
December 12, 2007 at 5:20 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply