General information
Forum:
Microsoft SQL Server
Title:
Deployment with sqlexpress
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only