MSDE 2000 connection error
-
I posted a couple of messages on this topic last month. I got a lot of great help and suggestions, but after taking the time to implement all of them I'm still not able to connect to my database over the network. Using the CodeProject tutorial: "Hands on how to configure the Microsoft MSDE" I just did a fresh install of MSDE 2000 enabling networking and using windows authentication. The instance is DomBenBSA running on computer DB-NGIVENS. I accidentally killed my testing database, but I recreated it and attached it to the server: it's BenefitSelectDB. So now I have the server running and I go to my laptop. I'm logged onto the domain (DB) with my standard login (NGIVENS). I'm using RapTier to try and connect to the database (it's just faster than running test C# connection strings). I can detect the server (DB-NGIVENS) - which is more than I could do before - but when I try to get to the database I get this error (when i'm using Windows Auth): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Here's the interesting thing. I go back over to the host machine where I have the server installed and check out my list of users. I don't see myself anywhere. So I add the user 'DB-NGIVENS'. When I try that, I get this error: Msg 15063, level 16, State 1, Server DB-NGIVENS\DOMBENBSA, Procedure sp_grantdbaccess, Line 116 The login already has an account under a different user name. So now I'm confused. If the login already has an account under a different name - how can I logon from another computer where I'm logged in as myself? Any help would be SO appreciated. (By the way, here are the users that I do find: db_accessadmin db_backupoperator db_datareader db_datawriter db_ddladmin db_denydatareader db_denydatawrier db_owner db_sercurityadmin dbo guest public) The ends can never justify the means. It is the means that determine the ends.