i can see one sql server browser running in configuration manager

I can see two instances under SQL Server Network Services in SQL Server config manager

In default instance:

Right clicked TCP/IP--> Properties---> Ip adresses .... I can see port number as...

checked remote connections for the instance set on. It is enabled.

Does each SQL Server listens on different port numbers?

for example: default on 1433 and named on something else ?

if we...

Thanks for the reply.

Here is the error message

-----------------------------------------

Cannot connect to servername\instancename

Additional information

A netowrk-related or instance-specific error occure while establising a connection to SQL Sevrer.

The server was not found or was...

do we need to have builtin adminsitrators enabled on sql server side inorder to have windows local admins login as single user mode usinf -m; as startup parameter?

sorry for asking that basic question?

How can i control the users? dont know who are connecting.

i tried connecting with management studio

i am getting login failed for user 'abc\xyz' 18456 error

i dont have login in sql server before and even no body does 🙂

plz suggest...

now i am in windows admin group restarted the service under singleusermode with -m; paramater

tried connecting with sqlcmd

c:\>sqlcmd -S pdba-cps

stil getting 18456 level 14 error

note:pdba-cps is servername

any suggestions plz help...

now my sa is locked out

tried to login using single user mode as mentioned here

http://blog.sqlauthority.com/2009/02/10/sql-server-start-sql-server-instance-in-single-user-mode/%5B/url%5D

i cant see startup parameters in advanced tab.

any suggestions ?

I am pulling the data with query

http://www.sqlserverbox.com/ssis-package-in-sql-server-agent-job-fails.html

http://sqlism.blogspot.com/2012/08/ssis-package-in-sql-server-agent-job.html

SSIS Package in SQL Server Agent Job Fails

Error:

Argument "xyz" for option "connection" is not valid. The command line parameters are invalid. The step failed.

Solution:

If your SQL Server...

Argument "xyz" for option "connection" is not valid. The command line parameters are invalid. The step failed.

I solved this issue by following

http://www.sqlserverbox.com/ssis-package-in-sql-server-agent-job-fails.html

http://sqlism.blogspot.com/2012/08/ssis-package-in-sql-server-agent-job.html

Great! This really helped me a lot lot lot.

Thank you:)

Thank you so much for the help!

I changed the protection level to EncryptSensitiveWithPassword

Please let me know syntax to "add /decrypt with the password"

Thanks a ton!