Viewing 15 posts - 901 through 915 (of 49,571 total)
SQL_Hacker - Wednesday, August 16, 2017 12:02 PMYou're missing "AS" in the "CREATE PROCEDURE" statement.
It's there, after the parameter list.
August 16, 2017 at 12:04 pm
If you're connecting to the instance "SERVER\Instance", then the login error will be in that instance's error log or, if you started SQL from the command line, will be on...
August 16, 2017 at 11:39 am
August 16, 2017 at 8:38 am
August 16, 2017 at 5:52 am
-S <server> -E should work. What's the error from the SQL Server error log?
August 16, 2017 at 5:50 am
Did you tell it which server/instance to connect to this time?
Just like any connection, you need to specify the server, the authentication (trusted or username and password) and...
August 16, 2017 at 5:31 am
sqlcmd /?
and look at the options it presents you.
August 16, 2017 at 5:14 am
A restore recreates the DB as it was at the time of backup. You can't split/merge or change files during a restore.
August 16, 2017 at 4:57 am
-U on sqlcmd is used along with -P for SQL logins, not windows. Use the parameter for trusted connection and make sure that you're logged into Windows as a local...
August 16, 2017 at 4:56 am
Have a look at the error log, see what the detailed description is for the login failure is.
August 16, 2017 at 3:50 am
Also make sure that you don't have something like SQL Agent or other services attempting to log in and taking the only login available.
August 16, 2017 at 3:41 am
Once you connect via SQLCMD, you can do anything. You're a sysadmin. So the same T-SQL you'd use normally to create a login and make it sysadmin.
August 16, 2017 at 3:40 am
Unless you have some custom auditing, SQL doesn't track when someone last logged on. If you need that, you'll have to set something up. An extended event session will probably...
August 16, 2017 at 3:36 am
When the instance is in single user mode, the only accounts that can log on are SQL sysadmins or windows users who are members of the local administrators group. If...
August 16, 2017 at 3:29 am
If you specified accounts at install, they'll be sysadmin. Log in as one of those and add extra accounts or change the sa password.
August 16, 2017 at 3:06 am
Viewing 15 posts - 901 through 915 (of 49,571 total)