Post reply

SQL Server does not exist or access denied.

  • October 26, 2010 at 1:18 am

    #230940

    Hi all,

    I have created a new database that is in go live stage. It is using mixed mode. All the services and agents are up and running. I am able to connect to database through admin account having windows authentication at database engine, but when i use the same account to login at the webpage based on the database, it is giving error "SQL Server does not exist or access denied."

    I have already enabled "using tcp/ip and named pipe" setting in remote connection setting through surface area configuration and all the 3 factors "shared memory, tcp/ip and named pipe" are enabled.

    Please help me out ASAP.

  • October 26, 2010 at 1:44 am

    #1242064

    try to register the new sql server from any other sql server. Are you still getting the same error? If not then the problem is with account which you configured in application to connect database.

    Please give proper permission on perticular database for the account which you using in your application.

    ----------
    Ashish

  • October 26, 2010 at 6:26 am

    #1242187

    Thanks a lot for quick help.

    I have checked the permissions and they were fine.

    Ultimately i solved it by replacing server ip by server_name\instance_name in weblogic file and i got login.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply