I have installed sqlserver2005 and WSS3.0. My DataBase server name is SPSERVER. but when i want to create a web application in WSS3.0, "SPSERVER\Microsoft##SSEE" is appeared in DataBase Server field instead of SPSERVER. and when i want to connect to sqlserver2005 throug this name "SPSERVER\Microsoft##SSEE" it gives me the following error. "--------------------------- Connection failed --------------------------- An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)" and when i try to connect to sql server2005 with this name "SPSERVER", it works fine. now tell me why two names instead of one?

It possibly comes from the way you installed WSS 3.0. Even if you already have a copy of SQL Server 2005 installed on the same server, it won't be used for your WSS 3.0 installation unless you select first Advanced installation (not Basic) and then do *not* specify single-server. In cases where you don't follow the above installation guidelines, the install routine will automatically install the version of SQL Server 2005 Express called "Windows Internal Database" (Microsoft##SSEE") and that will be used for the WSS 3.0 databases. 2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc. 2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow Both lists also include books in French; German; Spanish with even more languages in the 2007 list.

Now i am trying form authentication in for my site in sharepoint. when i run the asp.net_regsql it requires server name. what server name should i write in server name field. SPSERVER or SPSERVER\Microsoft##SSEE?