Can I change from Integrated Security?

When creating my database, I initially set it up to use Integrated Security (Windows Login), however I am having a hard time logging into the database on a consistent basis using this method. Can I now change to a specified user id and password? How would I do that? Would I lose any data in my database? Does the user id and password need to be the same user id and password used when logging into SQL Server?

Thank you.

The Authetication method is global to the server and not specific to the database.

When you change your authentication to mixed mode

The SA account becomes the most powerful account in the Sql server box

and can login in to all the databases in the server by default.

there are no data loss in the change.

reset the password of your SA account and makeuse of it.

|||

You can change the SQL Server security model to allow a SQL Server login

In the Object Explorer window, right-click on the Server, and then click on the [Security] page. Change to SQL Server and Windows Authentication mode. Then click [OK].

However, it is not conisdered a good practice to use the [sa] account. It represents a significant security risk. It is preferred to create a login for your purposes, and provide just enough permissions for that login to do its work.

Lesson 7: Understanding Security and Network Connectivity -from this series may be of help in understanding how to use SQL Server security.

SQL Server 2005 Express Video Learning
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#1

Can I buy 1 per seat license if I have 20 users login using same i

Hi,
May I know can I just buy 1 per seat license if I have 20 users login using
same id? If I have misunderstood this per seat license concept, pls highligh
t
to me.
Thanks
andrewNo. A seat does not correspond to a login id.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew|||Besides, per Seat was last available only on SQL Server 7.0. Now, your only
options are CAL based on per user or per device or per processor. This has
nothing to do with concurrent connections.
Sincerely,
Anthony Thomas
"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:u51B5$uKFHA.2284@.TK2MSFTNGP10.phx.gbl...
No. A seat does not correspond to a login id.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew

Can I buy 1 per seat license if I have 20 users login using same i

Hi,
May I know can I just buy 1 per seat license if I have 20 users login using
same id? If I have misunderstood this per seat license concept, pls highlight
to me.
Thanks
andrew
No. A seat does not correspond to a login id.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew
|||Besides, per Seat was last available only on SQL Server 7.0. Now, your only
options are CAL based on per user or per device or per processor. This has
nothing to do with concurrent connections.
Sincerely,
Anthony Thomas

"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:u51B5$uKFHA.2284@.TK2MSFTNGP10.phx.gbl...
No. A seat does not correspond to a login id.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew

Can I buy 1 per seat license if I have 20 users login using same i

Hi,
May I know can I just buy 1 per seat license if I have 20 users login using
same id? If I have misunderstood this per seat license concept, pls highlight
to me.
Thanks
andrewNo. A seat does not correspond to a login id.
--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew|||Besides, per Seat was last available only on SQL Server 7.0. Now, your only
options are CAL based on per user or per device or per processor. This has
nothing to do with concurrent connections.
Sincerely,
Anthony Thomas
"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:u51B5$uKFHA.2284@.TK2MSFTNGP10.phx.gbl...
No. A seat does not correspond to a login id.
--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew

Can i access SQL Login Users in ASP.Net application

Hello All,

I have SQL Server 2005 Installed and i have numbers of SQL Logins users which i want to use in my ASP.Net Application for authentication.

I am using ASP.Net 2.0 (VS.Net 2005).

Can i use the SQL Logins for ASP.Net web application authentication like the way we use Active Directory users?
Thanks in advance,
Wajahat Abbas
http://www.wajahatabbas.com

SQL Authentication is specific to SQL. You will not be able to use SQL Logins as you use Windows users.

See also:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaspnetauthentication.asp

Thanks
Laurentiu

|||

Thanks for replying.

Ya, i was thinking that with SQL 2005 and ASP.Net release, MS will increase the ASP.Net authenticaiton modes.

As SQL Server 2005 provides very cool features for SQL Users (like bad password, rating), so once we able to consume those things in ASP.Net it would be a peice of cake.
Anyway may be in next releases.

Thanks & Regards,
Wajahat Abbas
http://www.wajahatabbas.com
http://www.dotnetpakistan.com

Can i access SQL Login Users in ASP.Net application

Hello All,

I have SQL Server 2005 Installed and i have numbers of SQL Logins users which i want to use in my ASP.Net Application for authentication.

I am using ASP.Net 2.0 (VS.Net 2005).

Can i use the SQL Logins for ASP.Net web application authentication like the way we use Active Directory users?
Thanks in advance,
Wajahat Abbas
http://www.wajahatabbas.com

SQL Authentication is specific to SQL. You will not be able to use SQL Logins as you use Windows users.

See also:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaspnetauthentication.asp

Thanks
Laurentiu

|||

Thanks for replying.

Ya, i was thinking that with SQL 2005 and ASP.Net release, MS will increase the ASP.Net authenticaiton modes.

As SQL Server 2005 provides very cool features for SQL Users (like bad password, rating), so once we able to consume those things in ASP.Net it would be a peice of cake.
Anyway may be in next releases.

Thanks & Regards,
Wajahat Abbas
http://www.wajahatabbas.com
http://www.dotnetpakistan.com

Can create login but cannot connect (sa doesn't even work also)

Hi,

Please direct me to the right forum if this is not the right one.

Upon installation of SQL Server 2005, I opened the SQL Server Management Studio, connected using Windows Authentication and went to the security node in the tree. I created a log in called "TestLogin". I restarted my server just to make sure everything took and when I tried to log in using TestLogin via SQL Server Authentication, I get the below error. I have mixed mode enabled as well as named pipes. I am not sure what the issue is or what to try next. I even get the same error when trying to use "sa".

Thanks,

- Joel

TITLE: Connect to Server

Cannot connect to TestServer.

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

BUTTONS:

OK

Can you check the SQL Server errorlog and copy the last errors reported there?

Thanks
Laurentiu

|||Hi. I had the same problem. Username is case sensitiv and the error message is odd...

Can create login but cannot connect (sa doesn't even work also)

Hi,

Please direct me to the right forum if this is not the right one.

Upon installation of SQL Server 2005, I opened the SQL Server Management Studio, connected using Windows Authentication and went to the security node in the tree. I created a log in called "TestLogin". I restarted my server just to make sure everything took and when I tried to log in using TestLogin via SQL Server Authentication, I get the below error. I have mixed mode enabled as well as named pipes. I am not sure what the issue is or what to try next. I even get the same error when trying to use "sa".

Thanks,

- Joel

TITLE: Connect to Server

Cannot connect to TestServer.

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

BUTTONS:

OK

Can you check the SQL Server errorlog and copy the last errors reported there?

Thanks
Laurentiu

|||Hi. I had the same problem. Username is case sensitiv and the error message is odd...

Can connect from Query Analyzer but not from Report Services

I can terminal service into the box running Reporting Services. If I try to
run the
report I can't connect, it says login failed. Using the same
username/password which is sa because it's a log shipped server. I can
connect through Query Analizer. The only rememdy is to restart both servers.
Then I can connect. Then it will go hey wire after a day or two and same
situation. What could be causing this?
Please help me,
BryanAlso if I try to do net stop reportserver it says the server is not
responding to the control function. Actually the same thing happens if I try
to shut down the secondary log shipped server that the reports are pointing
at. If I do net stop mssqlserver. It gives me the same error. Something is
going on here between the two and I can't figure out what it is that is going
on?
"bmurtha" wrote:
> I can terminal service into the box running Reporting Services. If I try to
> run the
> report I can't connect, it says login failed. Using the same
> username/password which is sa because it's a log shipped server. I can
> connect through Query Analizer. The only rememdy is to restart both servers.
> Then I can connect. Then it will go hey wire after a day or two and same
> situation. What could be causing this?
> Please help me,
> Bryan

Can a Login/Password be validated against a Domain login/passord using a prompt dialog

I have an application database on SQL Server 2K and we've got an NT domain.
I want the users to type in their login and password, but I'd like to
validate that password against the windows NT Domain. Can this be done?
Jared HoffmanHi
This sounds like something that will not be permitted as you could then save
the users account details
You can use integrated security but you don't need a login box, unless you
want a secondary method of verification that you maintain.
John
"Jared Hoffman" <hoffmanj@.kenyon.edu.NO_SPAM> wrote in message
news:edQWKBfDEHA.3804@.TK2MSFTNGP09.phx.gbl...
> I have an application database on SQL Server 2K and we've got an NT
domain.
> I want the users to type in their login and password, but I'd like to
> validate that password against the windows NT Domain. Can this be done?
>
> Jared Hoffman
>|||If the users login to their domain, then they can simply use their nt
credentials to connect.
Change the SQL Server to use Windows Authentication. And change your
application connection string
to make Trusted Connections.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||My application will be used on computers that may or may not be joined to
the domain so I can't rely on Windows Authentication. I'd like to be able to
authenticate users in such a way I don't have to store another set of user
passwords.
Thanks,
Jared Hoffman
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:pd5X%23SfDEHA.3608@.cpmsftngxa06.phx.gbl...
> If the users login to their domain, then they can simply use their nt
> credentials to connect.
> Change the SQL Server to use Windows Authentication. And change your
> application connection string
> to make Trusted Connections.
>
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||previous post:
"My application will be used on computers that may or may not be joined to
the domain so I can't rely on Windows Authentication. I'd like to be able to
authenticate users in such a way I don't have to store another set of user
passwords.
"
Couple of options:
1. Standard SQL Security
2. Application roles
3. Trusted Security using duplicate nt username and passwords
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Can a Domain Group be set as the dbo to a database?

To keep the Login list more manageable and keep names out of it can I set a
AD Domain Group as the dbo to a database?
This would also help cover the cases when someone goes on vacation and a
different member of the group covers for them.You can add the group to Database Role db_owner.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Jim Abel" wrote:

> To keep the Login list more manageable and keep names out of it can I set
a
> AD Domain Group as the dbo to a database?
> This would also help cover the cases when someone goes on vacation and a
> different member of the group covers for them.