4 articles in SQL Services:
- Can I use SQL Enterprise manager to connect to my SQL database?
Yes! We allow our customers to connect with SQL Enterprise manager to manager databases.
- Principal (username) is not able to access the database
When connection to your MS SQL database remotely via Management Studio, you may receive the following error: Principal (username) is not able to access the database (dbname) under the current security context. This is because the MS SQL Server is attempting to execute a T-SQL query to retrieve a list of databases along with additional information about those databases. One of those pieces of information is "Collation", which you will not have permission to action for all databases as you're in a shared hosting environment and you only have access to your database alone. Use the following steps as a work-around: 1. In Object Explorer, click Databases2. Display Object Explorer Details (F7) or View > Object Explorer Details3....
- Enable remote connection to MS SQL 2008 instance
Some editions of MS SQL 2008 do not allow connections from a remote copy of Management Studio by default. You can enable this via the following steps: - Start Menu -> All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager- SQL Server Network Configuration -> Protocols for (instance name)- Right-click TCP/IP -> Properties- Protocol tab -- Enabled = Yes- IP Addresses tab -- IPAll -> TCP Port = 1433- You will need to restart your SQL instance through the serice manager (or by restarting your server) before this takes effect.- If you are running Microsoft Firewall (or another third-party firewall service), you will need to add an exception rule for incoming traffic on port 1433/TCP.
- Manually restore MS SQL database through Management Studio
This article was written for MS SQL 2005/2008: 1) MS SQL service generally runs with NETWORK SERVICE permissions. You will need to first move your backup file to a location readable by this user account. Typical examples are:C:C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupC:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLBackup2) If you have not done so already, create a SQL user login account for this database through Management Studio. Do not attempt to assign a User Mapping role at this point.3) Through Management Studio, right-click "Databases" -> Restore Database...4) Under "General":-If the database has not yet been created under this instance of MS SQL, enter the name under "To database:", otherwise select it from the drop-down list.-Select "From device" and click the browse button "...". Click "Add"...