Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deployment with sqlexpress
Message
From
04/09/2007 06:28:46
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Deployment with sqlexpress
Miscellaneous
Thread ID:
01252103
Message ID:
01252103
Views:
57
Hi,
I am using SQLEXPRESS to set up my database and use windows authentication. The system is developed in VB.NET and I have sucessfully set up the deployment.

After the installation on my own PC, it runs normally. However, when I transfered my deployemnt and the copy the database to the destination PC, it shows sqlexpress login failed error.

The destination PC has already installed the SQLEXPRESS. I realised that this is because the destination PC is not using the userid which is the same as my PC. Is there any way to change the database to the destination PC windows authentication account? Or any way to deploy the database to the destination PC together with the program? There are so data in the database, so I think it is not a good way to use the scripts. Thank you very much!
Reply
Map
View

Click here to load this message in the networking platform