SQL Server Does not exits or Access denied
-
We have sql server with the name production1 (IPID:100.102.33.33) ,from asp.net iam able to connect properly ,yesterday we changed the ip Id of this system(production1) from that time if iam trying to connect from asp.net code it is giving error sqlserver does not exists access denied. Iam able to connect in query analyzer for the same sql server by using same userid,password. Iam able to connect in vb.net for the same sql server with same connection string which iam using in asp.net Iam unable to connect in asp.net error sqlserver does not exists access denied. Please help me is there any problem with asp user or what? Thanks
-
We have sql server with the name production1 (IPID:100.102.33.33) ,from asp.net iam able to connect properly ,yesterday we changed the ip Id of this system(production1) from that time if iam trying to connect from asp.net code it is giving error sqlserver does not exists access denied. Iam able to connect in query analyzer for the same sql server by using same userid,password. Iam able to connect in vb.net for the same sql server with same connection string which iam using in asp.net Iam unable to connect in asp.net error sqlserver does not exists access denied. Please help me is there any problem with asp user or what? Thanks
Hai, add the user ASPNET to the database you are using. select the user from the list not by typing... the user must be in the list of local users list or add the production webserver aspnet user to the database, if iis and database are in different machine. this will work.. lot of links is available in google, try the appropriate one for you, cheers asithangae