This problem concerns a network connection between what I'll call machine A and machine B. On machine A, I can use SSMS to connect to a local database with no problem. But I'm having trouble getting SSMS on machine B to connect to SQLEXPRESS on machine A. I couldn't even get it to find the instance of SQLEXPRESS on machine A until I created a Guest user account with full permissions for the folder containing the database file. But when I try to connect to the server I get the error message below. I admit that at this point I'm lost. I don't know anything about SQL Server permissions, accounts and all that stuff - I've only been a local database user/VB programmer till now. Can anyone figure out what I need to do, or at least refer me to a good book that will give me some direction? Here's some more info about my configuration;
I'm using SQL Server Express 2008. I have Sequel Server Browser running on machine A. I have also shared the folder containing the database file, though I don't know if I really need to do that. I have TCP/IP enabled under SQL Server Network Configuration from the Configuration Manager.
TITLE: Connect to Server
Cannot connect to PDS\SQLEXPRESS.
Login failed for user 'PDS\Guest'. (Microsoft SQL Server, Error: 18456)
asked Apr 06 '10 at 06:36 PM in Default
You can have a look on below links.Jayant.firstname.lastname@example.org
answered Aug 12 '11 at 12:21 AM
Hi All ,
You can have a look on below links.
answered Aug 12 '11 at 12:20 AM
SQL Server Express has some default settings that can potentially cause connection problems from different machines and also how many connections are possible.
If you havent set them since installation then you need to check:
details here: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx - HOW TO: CONFIGURE EXPRESS TO ACCEPT REMOTE CONNECTIONS
answered Apr 07 '10 at 05:35 AM
Is PDS your computer name or is it your domain?
Have you granted permissions into the database for that account?
answered Apr 06 '10 at 06:50 PM