Yes you should do that with NT Integrated security if the account being
used on the running machine is established on SQL 2005 server and SQL 2005
express.
However, most would just use a generic user-id and psw for the logins one
for Server and one for Express and make two entries in AppSettings for
connections strings.
The recommend practice is to use Windows Auth from the service to SQL
Server. It's easier to configure, less maintentance, and much more secure.
In general, you should not use SQL Auth for much of anything these days.
There would be 2 connection strings in the AppConfig, one for each DB. Each
of these connection strings is marked to use Integrated Authentication.
RE: Fulltext failure on a 2 node cluster ...Server full-text search resource online: "SQL Cluster Resource 'Full Text' ... (microsoft.public.sqlserver.clustering)
Re: HELP PLEASE ~ ??? ... You mentioned that it went ahead and added a SQL...SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ... (microsoft.public.dotnet.framework.aspnet)
Re: Multi-Channel Raid VS SAN Storage ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ... (microsoft.public.sqlserver.setup)
Re: Multi-Channel Raid VS SAN Storage ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ... (microsoft.public.sqlserver.setup)
Re: Windows service ... I've actually done this before (we were hitting an Oracle DB that didn't support Windows Auth), using both the COM+ method recommend by the PAG group, and using the DPAPI method others have recommended. ... Windows Auth to the SQL Database is better in every way. ... I have not seen NT Authenticated user used for a means of connecting to a SQL Server database by any application, ... Some DBA's have a special sequence of characters to kind of encrypt the psw a kind of their own blend or take on the psw. ... (microsoft.public.dotnet.languages.csharp)
