Ask multi login sql

  • Hi Friend,

    I have question about SQL login use by 2 or 3 user connect from SSMS in the same time,

    Is there possible multi session login sql in SQL server 2005??

    please help

    regards

    Lilito

  • yes, if you have a valid username/password, you can connect multiple times.

    different people can connect from other computers using the same username and password as well.

    there is no practical limit to the number of connections.

    a good example is if you open SQL Sever Management Studio. every tab you open is a separate connection, and so is the object explorer. 4 tabs open, would be 4 connections, lus at least one for object explorer as well.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Thanks lowell, its solved.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply