First thanks for your reply
Quote:
Originally Posted by InkDevil
get sure port in sql-setting is opened&set to 1433.
|
I checked and it's set by defualt to 1433
but I don't how to check if it's open
Quote:
Originally Posted by InkDevil
Additionally check if your password in opt is correct (also don't forget compressing).
|
I checked the password many times and the key (which is 2011 I didn't change it),
plus I made sql not to enforce password (without changing sql password ofcourse)
and I compressed once with v2 compressor and another with v3
Quote:
Originally Posted by InkDevil
You used mixed mode and have 'sa' user activated?
|
I have used a mixed mode,
as for activating 'sa' user i didn't quit get it.
But I use 'sa' everytime I use sql, plus I made 'sa' the owner of the server's databases using this query
USE mydatabase
exec sp_changedbowner 'sa', 'true'
and I used this query to see if there is a database not owned by 'sa'
SELECT name AS DBName, suser_sname(owner_sid) AS DBOwner
FROM sys.databases
WHERE suser_sname(owner_sid) <> 'sa'
and all rappelz databases where owned by 'sa'