0
votes
2answers
871 views

Added a custom SQL Server login to Microsoft Dynamics CRM 4.0, getting empty resultsets

At work we have Microsoft Dynamics CRM 4.0 installed and employees use their LAN login to log into CRM's web interface. We've added a SQL Server-based custom login (to the server and db *_MSCRM) with ...
0
votes
1answer
1k views

Why does this login fail for user 'Servername\Guest'?

I install SQL Server 2005 EXPRESS edition on one computer, Computer Name = 'MyServe' and Database name='MyDB',take it as database server. it is configured as both Database and Windows Authentication ...
0
votes
1answer
103 views

Need to Create Login for groups in SQL SERVER 2005

Can anyone help me on this regarding by providing the exact code? I need to create two Logins named (Groups) 1. Dev_S 2. Dev_T Each Group has exactly fifty (50) Users (as Dev_S1, ...
0
votes
2answers
2k views

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection

Sql server is in Mixed Mode and I changed the user Password through Windows Authentication Mode from Security. After that when I try to connect the server it throw the error TITLE: Connect to Server ...
2
votes
1answer
1k views

Problem accessing MICROSOFT##SSEE database (Error: 18456, Severity: 14, State: 16.)

After an unexpected server shutdown due to a power failure, I can no longer connect to the internal windows database MICROSOFT##SSEE which is hosting Central Admin for my SBS 2008 server. The log ...
1
vote
1answer
209 views

How to monitor the total number of SQL Server logins

We have an SQL Server 2005 that is the backend of a web application. The application is partly SharePoint and partly web services accessing the database via Entity Framework. In the performance ...
2
votes
1answer
760 views

SQL Server 2005 does not start after installing SP3

I have a pretty ridiculous problem. So I've installed SQL Server 2005 on a Window Server 2008 machine. I was working my way through the service packs, provisioning two users to have full rights to ...
0
votes
1answer
71 views

SQL server login error

I am trying to login to SQL server 2005, and it gives me an error 18456.. This is very funny...I go to advanced option and set network protocol as TCP/IP it does not work..if I leave it as default it ...
0
votes
4answers
160 views

SQL Server 2005 login issue

I have SQL Server 2005 SP3 running one server with mixed mode authentication. I tried to connect to the database engine, using the SQL Management Studio installed on the same machine. But I get a ...