Cannot connect to database master at SQL server at SERVERNAME. The database might not exist, or the current user does not have permission to connect
I have installed SQL 2008 R2 with SP2 in a fresh Windows 2008 R2. I’m running the SharePoint configuration Wizard using the database server name with the correct domain credentials, but I get the following error message.
“Cannot connect to database master at SQL server at SERVERNAME. The database might not exist, or the current user does not have permission to connect”
I‘m able to login to the new SQL server using the “SQL server management studio” from DB server with no problems. where I used the sa account and a domain account.
I trace this problem by checking the following simple steps listed below:
- Check that you already typing the DB Server, domain user, and password correctly.
- Check If the SQL Server is already running.
- Check if the domain user has permission access to DB Server by connecting to DB server using Management Studio.
-If you can’t connect to DB Server using the domain user so it’s not have permission access and you need to permit it using SA account by connecting to DB server via Management Studio and from Security –> New Login-If you can connect so check the server role of this user it’s should have Dbcreator,Securityadmin permission.
- Check if the SQL Server Browser service is already started.
- Check SQL Server Network Configuration TCP/IP Enabled
- If all previous checking steps not working so you should check Firewall Settings. where Firewall can block access and communication with your Microsoft SQL Server server, so you have 3 possibilities
- Disable Firewall,
- Open windows firewall with advanced security.
- Right Click & Select Properties
- Let it On and Allow Inbound Connections
- Create Two Inbound Connections Rules
- One inbound TCP rule with ports: 1433,2383,2382.
- One inbound UPD rule with port: 1434.
In my case the problem in Firewall Setting and now it’s working
Enjoy :)
No comments:
Post a Comment