SQL Server login problem

[mlowry]

Using Visual Web Developer Express and SQL Server 2005 on an XP development machine. Was using development server in VWDE to view pages, using following connection string: |connectionStrings| |add name="RHConnectionString" connectionString="server=MIKE;database=Rotary;Trusted_Connection=True;"/| |remove name="LocalSqlServer"/| |/connectionStrings| Needed to test with SSL. Installed SSL certificate (using your makecert procedure, thanks). Moved web site to IIS and opened in VWDE. Development connection to database works, but pages get Login failed for user 'MIKE\IUSR_MIKE'. SQL Server configured for Remote Connections and mixed Windows Authentication and SQL Server authentication. Any help?

[Vimalsoft Pty Ltd]

Go to your management Studio. Right click your Server and go to properties. in the Properties go to Security and look at the Options under Server Authentication. and tell us what is selected there.

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

[cdpace]

Dont know if this may help but worth a try go to SAL Server Surface Area Configuration and then Surface are configuration for services and connections. Choose Remote connections, check Local and remote connections and choose TCP/IP only. Hope this helps ;)

[mlowry]

Thanks for your attempts to help. I "solved" the problem by creating a new user ID and giving it the access rights I was trying to give my primary Windows login ID.