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 custom tier above msmdpump.dll or create custom msmdpump.dll?

I want to hit Analysis Services over HTTP but with custom authentication. Is it possible to intercept the request before it gets to msmdpump and authenticate the user credentials coming from the client app? Or is it even possible to implement some interface or inherit from a base class and create my custom msmdpump.dll?It is possible using standard ISAPI filter interfaces. msmdpump.dll is ISAPI extenstion, and by putting your ISAPI filter before it, you can intercept the HTTP request, extract all the fields you want and set token thread according to your custome authentication. In fact, there are commercial products which do just that.|||I would like to do this in .NET but ISAPI filter can only be written in C or C++. Since all msmdpump does is send the request XMLA to Analysis Server, can I create a simple webpage that does the same thing?|||You are somewhat oversimplifying what msmdpump.dll does. The HTTP to TCP/IP transition involves translation of headers (some of them are custom), which is non-trivial piece, managing the pooling under different security settings etc. It is possible, of course, to replicate its functionality, but I am afraid "simple webpage" won't be enough to do it.

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??