Hi everyone!
I am bignner in vb.net and i have develo[ed a small application of vb forms in which i have use a service based sql server databas(.mdf)i want to make its msi installer last time i have made it and after installation application giving error for connecting to sql server plz help me.
thanks
aliftek 0 Newbie Poster
Oxiegen 88 Basically an Occasional Poster Featured Poster
If you're connecting to a networked SQL server, then perhaps the problem is the credentials.
If you're connecting through Windows Authentication, then other users may not have access to the server.
You should create a dedicated user on the SQL server, and use that account in the connectionstring for connecting to the server.
If you're using MS SQL Server Express, then this will be a good read:
http://msdn.microsoft.com/en-us/library/bb264562(SQL.90).aspx#emsqlexcustapp_topic4
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.