Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simplest way to copy whole database
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01301462
Message ID:
01301799
Views:
16
>I added the user, but I'm still getting
>
>'The user is not associated with a trusted SQL Server connection.'
>
>Do you know what should I do to make it work?
>
>Thanks in advance.
>
>I've tried to log through SSMS for this user and got
>
>TITLE: Connect to Server
>------------------------------
>
>Cannot connect to < Server name >
>
>------------------------------
>ADDITIONAL INFORMATION:
>
>A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
>
>For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
>
>------------------------------
>BUTTONS:
>
>OK
>------------------------------

Did you use the same login for both?
What are your rights for that user on your local computer?

Check what groups you have created on your local computer.

http://www.microcomplex.com/temp/windowsusers.jpg
http://www.microcomplex.com/temp/sqlserver.jpg
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform