Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Authorize user access to SQL Server 2008
Message
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Authorize user access to SQL Server 2008
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01488978
Message ID:
01488978
Views:
102
Hi,

I am stubbornly trying to connect my app from one computer to the SQL Server installed on another computer on my small LAN. With every step I think I am getting closer (just like to the horizon <g>).

Anyway, in the last attempt I am getting a message "Login Failed for user 'ComputerName\Guest'" The "ComputerName is the computer where SQL Server 2008 resides. Since SQL Server is configured for Windows Authentication I am figuring (guessing) that SQL Server "sees" me as a "Guest" user. What do I need to change (in Windows Users or SQL Server) to make SQL Server 2008 allow the access?

TIA.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Next
Reply
Map
View

Click here to load this message in the networking platform