RE: MSDE Running on Two Computers in Workgroup Mode
Date: Tue, 07 Dec 2004 10:01:17 GMT
Hi ,
There are a number of reasons why this error may occur:
Try using these steps:
1) Most probably you may not be able to logon on to the sql server using
windows authentication.
2) Try using windows authentication over named pipes instead fo tcp/ip to
connect to the sql server.
Make sure that you make use of an alias to do the task
This should fix the problem.
Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.
Relevant Pages
- Re: Windows authentication from ASP.NET to SQL Server
... > our intranet server and our database server, both of which are on our ... > Windows authentication works for our intranet server - my domain user ... Permissions on the SQL Server are ... > Successful Network Logon: ... (microsoft.public.dotnet.framework.aspnet.security) - Windows authentication from ASP.NET to SQL Server
... I am having trouble using Integrated Windows Authentication between our ... intranet server and our database server, both of which are on our local ... Windows authentication also works for the SQL Server; ... Successful Network Logon: ... (microsoft.public.dotnet.framework.aspnet.security) - Re: Cannot use Windows Authentication to connect to local Sql 2005
... I can't logon using Windows Authentication. ... Did you run the special Vista thing at the end of the SP2 setup? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... (microsoft.public.sqlserver.security) - Re: Credentials not being passed with remote access
... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ... (microsoft.public.sqlserver.security) - Re: User ASPNET in SQL Server 2000
... and turn off anonymous access. ... a logon box will pop up if the user cannot ... >While I love integrated security in SQL Server, ... (microsoft.public.dotnet.framework.aspnet.security) |
|