hi
I use plesk panel to upload my website I have database and i want conect to my host's database from sql2008 when i use this information
servername: mssql.mydomain.com
login: my database login : stest2 it is my login name
pass:my databasepass It is connected but when i click in object explorer/database The error occurs.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The server principal "stest2" is not able to access the database "Acupuncture" under the current security context. (Microsoft SQL Server, Error: 916)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.5500&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476
How can I access my DataBase in my host?Of course i know i can take backup from plesk panel but It takes a lot of time.
thanx