How to create sql server login for workgroup computer?

How can I add a new sql server login using windows authentication where the login id is from a user belonging in a workgroup?

No domain connection. Just a workgroup account will have a login in the sql server using windows authentication. Thanks
Thats not possible, WIndows authentication can be used if the server can prove your identity. I a (non-trusted) workgroup, this is not possible, because everyone can join the workgoup and could spoof another ones identity.

You can only use the local accounts of the SQL Server to do so. In those enviroments you can impersonate the user with a remote account on the SQL Server machine programmatically (like in C# to run under a remote account of the SQL Server box).

There is another way of choosing the same name and the same password on the SQL Server as well as on the client bix, but I don′t think and stated that several times, that this is not a proficient solution.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

How to create a SQL CE database in a Windows Application

Hi my
name is Abdel Lopez, I wonder if you can help me.
What I want to do is create and populate a SQL CE database in a Windows
application, do you know how can I do it'
I'm not so worried about transfering the file to the Pocket PC right
now, my main task is to create and populate the SQL CE
in a Windows environment.
Hope you can help me, Thanx
AbdelPlease do not multipost, anwered in .Server.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Abdel" <Abdel@.discussions.microsoft.com> schrieb im Newsbeitrag
news:35B48C2E-6533-4A21-886A-DAA2A9D23CB1@.microsoft.com...
> Hi my
> name is Abdel Lopez, I wonder if you can help me.
> What I want to do is create and populate a SQL CE database in a Windows
> application, do you know how can I do it'
> I'm not so worried about transfering the file to the Pocket PC right
> now, my main task is to create and populate the SQL CE
> in a Windows environment.
> Hope you can help me, Thanx
> Abdel
>

How to create a SQL CE database in a Windows Application

Hi my
name is Abdel Lopez, I wonder if you can help me.
What I want to do is create and populate a SQL CE database in a Windows
application, do you know how can I do it'
I'm not so worried about transfering the file to the Pocket PC right
now, my main task is to create and populate the SQL CE
in a Windows environment.
Hope you can help me, Thanx
AbdelI don´t understand your issue, but I will try to help you anyway. if you are
planing to deploy an PocketPC allplication and want to test the SQlServer
(CE) Installation on that there is a SDK from Microsoft for ProcketPC where
you can easily test the enviroment. It runs a virtual PocketPC where you can
install and run programs like on the physical one. AFIAK there is no way to
install and use SQL CE on a Windows plattform.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Abdel" <Abdel@.discussions.microsoft.com> schrieb im Newsbeitrag
news:22D36A14-3B5E-434A-94C7-15EBAEB599D7@.microsoft.com...
> Hi my
> name is Abdel Lopez, I wonder if you can help me.
> What I want to do is create and populate a SQL CE database in a Windows
> application, do you know how can I do it'
> I'm not so worried about transfering the file to the Pocket PC right
> now, my main task is to create and populate the SQL CE
> in a Windows environment.
> Hope you can help me, Thanx
> Abdel|||Hi
what I want to do is create a SQL CE database, its tables, fields, and
information using a Win32 application (like one created in Visual C++, C#
or Visual Basic), and then after I created such DB simply transfering to a
Pocket PC.|||http://asia.cnet.com/builder/program/windows/0,39009376,39172017,00.htm
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Abdel Lopez via SQLMonster.com" <forum@.SQLMonster.com> schrieb im
Newsbeitrag news:95069a5d4a7a4ccd8315791cadff6bc8@.SQLMonster.com...
> Hi
> what I want to do is create a SQL CE database, its tables, fields, and
> information using a Win32 application (like one created in Visual C++, C#
> or Visual Basic), and then after I created such DB simply transfering to a
> Pocket PC.

How to create a SQL CE database in a Windows Application

Hi my
name is Abdel Lopez, I wonder if you can help me.
What I want to do is create and populate a SQL CE database in a Windows
application, do you know how can I do it?
I'm not so worried about transfering the file to the Pocket PC right
now, my main task is to create and populate the SQL CE
in a Windows environment.
Hope you can help me, Thanx
Abdel
I dont understand your issue, but I will try to help you anyway. if you are
planing to deploy an PocketPC allplication and want to test the SQlServer
(CE) Installation on that there is a SDK from Microsoft for ProcketPC where
you can easily test the enviroment. It runs a virtual PocketPC where you can
install and run programs like on the physical one. AFIAK there is no way to
install and use SQL CE on a Windows plattform.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Abdel" <Abdel@.discussions.microsoft.com> schrieb im Newsbeitrag
news:22D36A14-3B5E-434A-94C7-15EBAEB599D7@.microsoft.com...
> Hi my
> name is Abdel Lopez, I wonder if you can help me.
> What I want to do is create and populate a SQL CE database in a Windows
> application, do you know how can I do it?
> I'm not so worried about transfering the file to the Pocket PC right
> now, my main task is to create and populate the SQL CE
> in a Windows environment.
> Hope you can help me, Thanx
> Abdel
|||Hi
what I want to do is create a SQL CE database, its tables, fields, and
information using a Win32 application (like one created in Visual C++, C#
or Visual Basic), and then after I created such DB simply transfering to a
Pocket PC.
|||http://asia.cnet.com/builder/program...9172017,00.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Abdel Lopez via droptable.com" <forum@.droptable.com> schrieb im
Newsbeitrag news:95069a5d4a7a4ccd8315791cadff6bc8@.droptable.co m...
> Hi
> what I want to do is create a SQL CE database, its tables, fields, and
> information using a Win32 application (like one created in Visual C++, C#
> or Visual Basic), and then after I created such DB simply transfering to a
> Pocket PC.

How to create a SQL CE database in a Windows Application

Hi my
name is Abdel Lopez, I wonder if you can help me.
What I want to do is create and populate a SQL CE database in a Windows
application, do you know how can I do it'
I'm not so worried about transfering the file to the Pocket PC right
now, my main task is to create and populate the SQL CE
in a Windows environment.
Hope you can help me, Thanx
AbdelI dont understand your issue, but I will try to help you anyway. if you are
planing to deploy an PocketPC allplication and want to test the SQlServer
(CE) Installation on that there is a SDK from Microsoft for ProcketPC where
you can easily test the enviroment. It runs a virtual PocketPC where you can
install and run programs like on the physical one. AFIAK there is no way to
install and use SQL CE on a Windows plattform.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Abdel" <Abdel@.discussions.microsoft.com> schrieb im Newsbeitrag
news:22D36A14-3B5E-434A-94C7-15EBAEB599D7@.microsoft.com...
> Hi my
> name is Abdel Lopez, I wonder if you can help me.
> What I want to do is create and populate a SQL CE database in a Windows
> application, do you know how can I do it'
> I'm not so worried about transfering the file to the Pocket PC right
> now, my main task is to create and populate the SQL CE
> in a Windows environment.
> Hope you can help me, Thanx
> Abdel|||Hi
what I want to do is create a SQL CE database, its tables, fields, and
information using a Win32 application (like one created in Visual C++, C#
or Visual Basic), and then after I created such DB simply transfering to a
Pocket PC.|||http://asia.cnet.com/builder/progra...39172017,00.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Abdel Lopez via droptable.com" <forum@.droptable.com> schrieb im
Newsbeitrag news:95069a5d4a7a4ccd8315791cadff6bc8@.SQ
droptable.com...
> Hi
> what I want to do is create a SQL CE database, its tables, fields, and
> information using a Win32 application (like one created in Visual C++, C#
> or Visual Basic), and then after I created such DB simply transfering to a
> Pocket PC.

How to create a new failover cluster

At the beginning , I installed SQL server 2000 on two seperate computers
running the windows 2003 cluster and there is no problem . Cause SQL server
is cluster-aware setup program. But Today , I lost one of them. the first
computer's operating system crashed.
Now I want to add a new sql server to the cluster as a new node .
what should I do ?
on the new computer I do the following steps
1. install windows 2003 ( ok )
2. use cluadmin , add new node to cluster. (ok )
3. install sql2000 enterprise .
choice
A.local server
B.remote server
C.virtual server.
I choiced C.Virtual Server and gives the bios nameI found the step on msdn . thanks
http://msdn.microsoft.com/library/d...
ering_084y.asp
"william.huang" <william.huang@.saturn.yzu.edu.tw> glsD:%23a6HuVc8GHA.4572@.TK2MSFTN
GP02.phx.gbl...
> At the beginning , I installed SQL server 2000 on two seperate computers
> running the windows 2003 cluster and there is no problem . Cause SQL
> server is cluster-aware setup program. But Today , I lost one of them. the
> first computer's operating system crashed.
> Now I want to add a new sql server to the cluster as a new node .
> what should I do ?
> on the new computer I do the following steps
> 1. install windows 2003 ( ok )
> 2. use cluadmin , add new node to cluster. (ok )
> 3. install sql2000 enterprise .
> choice
> A.local server
> B.remote server
> C.virtual server.
> I choiced C.Virtual Server and gives the bios name
> .
> .
> .
> .
> Fail screen
> is the steps correct ?
> Regards,
> William
>
>
>

How to create a new failover cluster

At the beginning , I installed SQL server 2000 on two seperate computers
running the windows 2003 cluster and there is no problem . Cause SQL server
is cluster-aware setup program. But Today , I lost one of them. the first
computer's operating system crashed.
Now I want to add a new sql server to the cluster as a new node .
what should I do ?
on the new computer I do the following steps
1. install windows 2003 ( ok )
2. use cluadmin , add new node to cluster. (ok )
3. install sql2000 enterprise .
choice
A.local server
B.remote server
C.virtual server.
I choiced C.Virtual Server and gives the bios name
I found the step on msdn . thanks
http://msdn.microsoft.com/library/de...ering_084y.asp
"william.huang" <william.huang@.saturn.yzu.edu.tw> glsD:%23a6HuVc8GHA.4572@.TK2MSFTNGP02.phx .gbl...
> At the beginning , I installed SQL server 2000 on two seperate computers
> running the windows 2003 cluster and there is no problem . Cause SQL
> server is cluster-aware setup program. But Today , I lost one of them. the
> first computer's operating system crashed.
> Now I want to add a new sql server to the cluster as a new node .
> what should I do ?
> on the new computer I do the following steps
> 1. install windows 2003 ( ok )
> 2. use cluadmin , add new node to cluster. (ok )
> 3. install sql2000 enterprise .
> choice
> A.local server
> B.remote server
> C.virtual server.
> I choiced C.Virtual Server and gives the bios name
> .
> .
> .
> .
> Fail screen
> is the steps correct ?
> Regards,
> William
>
>
>

How to create a new failover cluster

At the beginning , I installed SQL server 2000 on two seperate computers
running the windows 2003 cluster and there is no problem . Cause SQL server
is cluster-aware setup program. But Today , I lost one of them. the first
computer's operating system crashed.
Now I want to add a new sql server to the cluster as a new node .
what should I do ?
on the new computer I do the following steps
1. install windows 2003 ( ok )
2. use cluadmin , add new node to cluster. (ok )
3. install sql2000 enterprise .
choice
A.local server
B.remote server
C.virtual server.
I choiced C.Virtual Server and gives the bios name
.
.
.
.
Fail screen
is the steps correct ?
Regards,
WilliamI found the step on msdn . thanks
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_clustering_084y.asp
"william.huang" <william.huang@.saturn.yzu.edu.tw> ¼¶¼g©ó¶l¥ó·s»D:%23a6HuVc8GHA.4572@.TK2MSFTNGP02.phx.gbl...
> At the beginning , I installed SQL server 2000 on two seperate computers
> running the windows 2003 cluster and there is no problem . Cause SQL
> server is cluster-aware setup program. But Today , I lost one of them. the
> first computer's operating system crashed.
> Now I want to add a new sql server to the cluster as a new node .
> what should I do ?
> on the new computer I do the following steps
> 1. install windows 2003 ( ok )
> 2. use cluadmin , add new node to cluster. (ok )
> 3. install sql2000 enterprise .
> choice
> A.local server
> B.remote server
> C.virtual server.
> I choiced C.Virtual Server and gives the bios name
> .
> .
> .
> .
> Fail screen
> is the steps correct ?
> Regards,
> William
>
>
>

How to copy production master db into test environment

SQL Server 2000 (sp3a) running on Windows 2000 (sp3)
My goal is to re-create our production environment in a test environment, on
a test sql server.
What is the proper method for copying the contents of our production
'master' database to a test server?
I've tried multiple DTS exports into the test server's 'master' database
without success.
Appreciate any help and suggestions.
ZawI prefer using BACKUP and RESTORE for this. You then have to handle your
users/logins mappings. Read about sp_change_users_login in Books Online for
more info on that.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"zaw" <threewise@.comcast.net> wrote in message
news:uYurJ5IqDHA.1960@.TK2MSFTNGP12.phx.gbl...
> SQL Server 2000 (sp3a) running on Windows 2000 (sp3)
> My goal is to re-create our production environment in a test environment,
on
> a test sql server.
> What is the proper method for copying the contents of our production
> 'master' database to a test server?
> I've tried multiple DTS exports into the test server's 'master' database
> without success.
> Appreciate any help and suggestions.
> Zaw
>|||i don't know what you want out of master, but if it's just logins use
sp_help_revlogin.
if it's jobs, script jobs on prod and use script to recreate on test after
editing appropriately.
if it's dts packages, save them to test server and then edit appropriately.
if it's databases, backup on prod and restore to test.
if it's publications and subscriptions, good luck ;)
zaw wrote:
> SQL Server 2000 (sp3a) running on Windows 2000 (sp3)
> My goal is to re-create our production environment in a test environment, on
> a test sql server.
> What is the proper method for copying the contents of our production
> 'master' database to a test server?
> I've tried multiple DTS exports into the test server's 'master' database
> without success.
> Appreciate any help and suggestions.
> Zaw

how to copy database?

i have an database created with MSDE using the windows authentication,and now i want to send this database to someone, can i just backup thisdatabase and send it,
can other people access my database with windows authenticaiton in his computer ? or i need to do some extra stuff?
I havent used MSDE but normally you can copy the mdf and ldf files and paste them in the Data folder of the server you want to move it onto and do an "Attach" database. right click on databases and select "Attach database" and follow the wizard.|||

Theoretically, If you're using Windows Authentication - anyone in the domain would be able to access the database, once they're logged into the domain...(with the right tools, of course)

You can back it up or you can detach it and send the two files (.mdf and .ldf) files to the other person - they can then attach the files to their own server.

|||unfortunately the people i want to send is not in the domain
but i have stored procedures within in the database, and when i detachthe database , will they not be ask some password stuff?? becausei this database used window authentication.
can i somehow get rid of this windows authentication to use the normal password version??