Guest lcpriya Posted April 4, 2006 Share Posted April 4, 2006 i have created an asp.net application with sql server2000 as backend in my localsystem.when i deployed the project in other sytem in network,i receive the following error message."sql server does not exsist or access denied"when i create the same database in local system and change the data source name with local system in configuration file, the application is working.i do not face this problem with vb.net application as it takes its datasource from network system.is there anything like i have to give permission for asp.net in sql server network utility.can anyone sort out the problem Link to comment Share on other sites More sharing options...
aspnetguy Posted April 4, 2006 Share Posted April 4, 2006 When setting up my asp.net applications with sql server 2000 I had to create a user in sql server 2000 called 'network service' this is the account the .net code runs as (the account is 'aspnet' if using windows xp).Make sure you create a sql server account named 'network service' and give it permission.Also is the Sql server on the same machine as your .net application or are you trying to remotely connect to sql server? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now