How can I connect to a remote sql server using windows authentication?

It is simple

1- I open the Sql Server 2005 Management Studio

2- I select Windows Authentication from the drop down.

3- I cannot write the user name and password, it chooses the default once, the one I am logged in with!

But I am in a virtual machine outside the domain controller, I can access shares on machines that are on the domain controller, thanks to the file sharing of windows, but I cannot login to sql server, thanks to a meaningless restriction on that dialog :-)

Now, how can I still use the Windows Authentication and login, how can I avoid the sql server authentication?

If you are outside domain, then you should use SQL Authentication.|||

Ok, then why the text boxes for the user name and password are still there if I choose the Windows authentication, and the text boxes have the user name already filled in, and all are disabled.

What is the point of having those there? In my case, I was trying to find a way to enable them from the settings; I guess just a false hope.

And why cannot I use the windows authentication? NTFS does allow me to do it and access the file system from outside the domain using windows authentication against the domain, what does make sql server more special?

|||

The reason for the textbox is just to let you know which Windows account is being used to connect to SQL Server using Windows authentication. To access SQL Server using SQL authentication, click the Authentication drop-down to see the SQL Server Authentication option. You'll see the User name and Password textboxes enabled.

If you want to use Windows authentication, the easiest way is to join your SQL Server to your domain.

|||

Thank you for the help, but I know how to use the SQL Server authentication, and the SQL Server is the development server and it is on the domain.

My virtual machine is the development machine, it is a virtual machine and it cannot join the domain, it must stay as it is, the real machine is on the domain, but the virtual machine that I am trying to use is not.

From the virtual machine I can do lots of things, including accessing the file system and the intranet sites on the domain, using the domain authentication box, or cached credentials, but I cannot do that with the SQL Server.

|||

if you want an nt authentication

then you must promote your virtual machine to a domain controller

how can I connect to .MDF through 2 applications?

Here is the big problem:

I am using ASP.NET 2.0 login control. this control connect to ASPNET.MDF database.I built another application using windows service, and this application also connects to ASPNET.MDF database.

problem is that the first application that connects to the database, locks the database, and so the other application cannot use the database untill the other application is closed.

I am going on circles about this, and just don't know what to do.

Please please please. love me do.

I don't think you can use the membership database for none Asp.net application because a console application is not Asp.net application, but if you could maybe you should create one for each application as the link below from a Microsoft security forum. The reason is by default every application uses the same application name to access the database so why not create one for each application so it is clean. Post again if you still have question. Hope this helps.

http://aspalliance.com/groups/microsoft_public_dotnet_framework_aspnet_security/ng-645637_Membership_Database_Security.aspx

sql

How can i check the time the Database is using?

My SQL 2000 server seems to be logging data an hour early, the Windows 2003
time is correct though. What steps should I take to find out what is
happening. I'm in the UK and we have to change our clocks for day light,
but these are all set to automatically adjust clocks.
Should it be using the local server time?I had a discussion with an Microsoft Consultant about this, from what I
remember. He said SQL server doesn't have time-zone setting it grabs it's
information from the Server its running on. So maybe check the settings on
the server ..
Ref Link: http://support.microsoft.com/?kbid=928388
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Gonzo" wrote:

> My SQL 2000 server seems to be logging data an hour early, the Windows 200
3
> time is correct though. What steps should I take to find out what is
> happening. I'm in the UK and we have to change our clocks for day light,
> but these are all set to automatically adjust clocks.
> Should it be using the local server time?
>|||SQL Server gets it date and time from the server itself thru an internal
winapi call. So if the server is correct then so is SQL Server. If you are
supplying the datetimes via the client as a value in the insert statement
then the client may be an hour behid. Can you post the actual code that is
doing the inserts?
Andrew J. Kelly SQL MVP
"Gonzo" <no@.no123.com> wrote in message
news:CF181373-2F00-4EE0-9B7F-6EAC76C705BE@.microsoft.com...
> My SQL 2000 server seems to be logging data an hour early, the Windows
> 2003 time is correct though. What steps should I take to find out what is
> happening. I'm in the UK and we have to change our clocks for day light,
> but these are all set to automatically adjust clocks.
> Should it be using the local server time?sql

How can i check the time the Database is using?

My SQL 2000 server seems to be logging data an hour early, the Windows 2003
time is correct though. What steps should I take to find out what is
happening. I'm in the UK and we have to change our clocks for day light,
but these are all set to automatically adjust clocks.
Should it be using the local server time?I had a discussion with an Microsoft Consultant about this, from what I
remember. He said SQL server doesn't have time-zone setting it grabs it's
information from the Server its running on. So maybe check the settings on
the server ..
Ref Link: http://support.microsoft.com/?kbid=928388
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Gonzo" wrote:
> My SQL 2000 server seems to be logging data an hour early, the Windows 2003
> time is correct though. What steps should I take to find out what is
> happening. I'm in the UK and we have to change our clocks for day light,
> but these are all set to automatically adjust clocks.
> Should it be using the local server time?
>|||SQL Server gets it date and time from the server itself thru an internal
winapi call. So if the server is correct then so is SQL Server. If you are
supplying the datetimes via the client as a value in the insert statement
then the client may be an hour behid. Can you post the actual code that is
doing the inserts?
--
Andrew J. Kelly SQL MVP
"Gonzo" <no@.no123.com> wrote in message
news:CF181373-2F00-4EE0-9B7F-6EAC76C705BE@.microsoft.com...
> My SQL 2000 server seems to be logging data an hour early, the Windows
> 2003 time is correct though. What steps should I take to find out what is
> happening. I'm in the UK and we have to change our clocks for day light,
> but these are all set to automatically adjust clocks.
> Should it be using the local server time?

How can I change the login name and password?

How can I change the login name and password? Quite frankly, I would like the
login name to be same as my WIndows login and no passwrod.
Syntax
sp_password [ [ @.old = ] 'old_password' , ]
{ [ @.new =] 'new_password' }
[ , [ @.loginame = ] 'login' ]
HTH, Jens Suessmeyer.
"Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
news:9BA17C7E-07B5-43DE-BADF-F15AA921DF52@.microsoft.com...
> How can I change the login name and password? Quite frankly, I would like
> the
> login name to be same as my WIndows login and no passwrod.
|||I typed exactly what you wrote, except for the brackets, at a command prompt.
I got the error message that sp_password is not a recognized command. Is
there a particular folder I have to be in for this to work? If I want to
leave the password blank do I just not enter nothing or do I use the word
null.
Thanks for your help
"Jens Sü?meyer" wrote:

> Syntax
> sp_password [ [ @.old = ] 'old_password' , ]
> { [ @.new =] 'new_password' }
> [ , [ @.loginame = ] 'login' ]
>
> HTH, Jens Suessmeyer.
> "Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:9BA17C7E-07B5-43DE-BADF-F15AA921DF52@.microsoft.com...
>
>
|||master..sp_password 'myoldone','mynewone','theusername'
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0B925CDD-32D6-49A1-B132-75C56007289B@.microsoft.com...[vbcol=seagreen]
>I typed exactly what you wrote, except for the brackets, at a command
>prompt.
> I got the error message that sp_password is not a recognized command. Is
> there a particular folder I have to be in for this to work? If I want to
> leave the password blank do I just not enter nothing or do I use the word
> null.
> Thanks for your help
> "Jens Smeyer" wrote:
|||sp_password still comes up as an invalid command. In your second example you
omitted @.old, etc. Please give me the exact syntax and command.
Thanks again
"Jens Sü?meyer" wrote:

> master..sp_password 'myoldone','mynewone','theusername'
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:0B925CDD-32D6-49A1-B132-75C56007289B@.microsoft.com...
>
>
|||My first post was the common expression based on BOL Syntax.
Where do you fire the commadn to the SQL Server, from OSQL ?
Jens Suessmeyer.
"Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
news:11D32945-2151-4EFE-9608-CCEA419BDE07@.microsoft.com...[vbcol=seagreen]
> sp_password still comes up as an invalid command. In your second example
> you
> omitted @.old, etc. Please give me the exact syntax and command.
> Thanks again
> "Jens Smeyer" wrote:
|||Sorry but I don't know what BOL means. OSQL? I typed the command from a
command promt. I thought I was in the wrong folder so I did a search of the
entire drive for the command sp_password and couldn't find it.
Sorry to be such a pest. I really appreciate you sticking with me.
Marty
"Jens Sü?meyer" wrote:

> My first post was the common expression based on BOL Syntax.
> Where do you fire the commadn to the SQL Server, from OSQL ?
> Jens Suessmeyer.
> "Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:11D32945-2151-4EFE-9608-CCEA419BDE07@.microsoft.com...
>
>
|||-BOL (Books Online) Help for SQL Server included in the installing package.
-OSQL Commandline Uitl to query the SQl Server.
Start --> Run --> Cmd --> Then the command i send to you. here you can
execute the sp_chanegpassword command.
Further information, just raise a hand, you are not bothering me :-)
HTH, Jens Suessmeyer.
"Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
news:7B1AAD94-C5A0-4782-8BA6-2B1F6DC95E5E@.microsoft.com...[vbcol=seagreen]
> Sorry but I don't know what BOL means. OSQL? I typed the command from a
> command promt. I thought I was in the wrong folder so I did a search of
> the
> entire drive for the command sp_password and couldn't find it.
> Sorry to be such a pest. I really appreciate you sticking with me.
> Marty
> "Jens Smeyer" wrote:
|||I'm afraid I'm still lost. What folder to I have to be in when I execute the
command line? I have tried the command line at a command promt and get the
message that it is an unreconizeable command. Am I dumber than I thought?
"Jens Sü?meyer" wrote:

> -BOL (Books Online) Help for SQL Server included in the installing package.
> -OSQL Commandline Uitl to query the SQl Server.
> Start --> Run --> Cmd --> Then the command i send to you. here you can
> execute the sp_chanegpassword command.
> Further information, just raise a hand, you are not bothering me :-)
> HTH, Jens Suessmeyer.
> "Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:7B1AAD94-C5A0-4782-8BA6-2B1F6DC95E5E@.microsoft.com...
>
>
|||By the way, I found the article and the syntax is exactly what you said it
was. But I still get the error
"Jens Sü?meyer" wrote:

> -BOL (Books Online) Help for SQL Server included in the installing package.
> -OSQL Commandline Uitl to query the SQl Server.
> Start --> Run --> Cmd --> Then the command i send to you. here you can
> execute the sp_chanegpassword command.
> Further information, just raise a hand, you are not bothering me :-)
> HTH, Jens Suessmeyer.
> "Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:7B1AAD94-C5A0-4782-8BA6-2B1F6DC95E5E@.microsoft.com...
>
>

How can I be notified when record is updated

I want to build an windows application by using a visual C# to Notify the user that his data in the database had been changed ..such like "New Message In Your Mail Box Alert"..So I need to know if there is way that to let the SQL Server send a notify (just like Trigger) ..

osmansays,
Combine a trigger and a stored procedure to send a email on updates
--------------------------------
Procedure like :
Create Procedure sp_SMTPMail
@.SenderName varchar(100),
@.SenderAddress varchar(100),
@.RecipientName varchar(100),
@.RecipientAddress varchar(100),
@.Subject varchar(200),
@.Body varchar(8000),
@.MailServer varchar(100) = 'localhost'
AS

SET nocount on
declare @.oMail int
declare @.resultcode int
EXEC @.resultcode = sp_OACreate 'SMTPsvg.Mailer', @.oMail OUT
if @.resultcode = 0
BEGIN
EXEC @.resultcode = sp_OASetProperty @.oMail, 'RemoteHost', @.mailserver
EXEC @.resultcode = sp_OASetProperty @.oMail, 'FromName', @.SenderName
EXEC @.resultcode = sp_OASetProperty @.oMail, 'FromAddress', @.SenderAddress
EXEC @.resultcode = sp_OAMethod @.oMail, 'AddRecipient', NULL, @.RecipientName, @.RecipientAddress
EXEC @.resultcode = sp_OASetProperty @.oMail, 'Subject', @.Subject
EXEC @.resultcode = sp_OASetProperty @.oMail, 'BodyText', @.Body
EXEC @.resultcode = sp_OAMethod @.oMail, 'SendMail', NULL
EXEC sp_OADestroy @.oMail
END
SET nocount off
--------------------------------
Trigger like :
CREATE TRIGGER trgDataChanged on tblData
AFTER UPDATE
AS
BEGIN
exec sp_SMTPMail @.SenderName='me', @.SenderAddress='me@.somewhere.com', @.RecipientName = 'Someone', @.RecipientAddress = 'someone@.someplace.com', @.Subject='SQL Data Change', @.body='data in table tblData has been changed'
END
--------------------------------
If you also want to track the changes you can either translate the query to simple data or show the data that is changed but to view that you need to walk through the recordset with for instance a cursor.
Peter

How can i backup sql 2000 using win 2003 backup util

Hi
I have a windows 2003 server running sql. I would like to backup SQL 2000
databases using the built in backup software to a network location.
Could anyone tell me how i do this.
Thanks
Nick
To do this properly, you would have to take the databases offline, or stop
the SQL Server service.
Are you not able to use the built-in-and-highly-effective SQL Server backup
and then take those .bak files to a network location?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Nick" <andync55@.hotmail.com> wrote in message
news:OvQct%23a1FHA.2428@.tk2msftngp13.phx.gbl...
> Hi
> I have a windows 2003 server running sql. I would like to backup SQL 2000
> databases using the built in backup software to a network location.
> Could anyone tell me how i do this.
>
> Thanks
> Nick
>
|||Hi
Thanks for the fast reply. Can i do that by right clicking on each databse
and selecting backup. Is that all i need to do. Is there any other sql
setting i should backup other than just the databases.
Thanks
Nick Comper
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:ehe21Jb1FHA.3660@.TK2MSFTNGP15.phx.gbl...
> To do this properly, you would have to take the databases offline, or stop
> the SQL Server service.
> Are you not able to use the built-in-and-highly-effective SQL Server
> backup and then take those .bak files to a network location?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "Nick" <andync55@.hotmail.com> wrote in message
> news:OvQct%23a1FHA.2428@.tk2msftngp13.phx.gbl...
>
|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Nick" <andync55@.hotmail.com> wrote in message
news:eLJqeOb1FHA.3720@.TK2MSFTNGP14.phx.gbl...
> Hi
> Thanks for the fast reply. Can i do that by right clicking on each databse
> and selecting backup. Is that all i need to do. Is there any other sql
> setting i should backup other than just the databases.
> Thanks
> --
> Nick Comper
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:ehe21Jb1FHA.3660@.TK2MSFTNGP15.phx.gbl...
>
|||Hi
Thanks for the fast reply. Can i do that by right clicking on each databse
and selecting backup. Is that all i need to do. Is there any other sql
setting i should backup other than just the databases.
Thanks
Nick Comper
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:ehe21Jb1FHA.3660@.TK2MSFTNGP15.phx.gbl...
> To do this properly, you would have to take the databases offline, or stop
> the SQL Server service.
> Are you not able to use the built-in-and-highly-effective SQL Server
> backup and then take those .bak files to a network location?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "Nick" <andync55@.hotmail.com> wrote in message
> news:OvQct%23a1FHA.2428@.tk2msftngp13.phx.gbl...
>

How can i backup sql 2000 using win 2003 backup util

Hi
I have a windows 2003 server running sql. I would like to backup SQL 2000
databases using the built in backup software to a network location.
Could anyone tell me how i do this.
Thanks
NickTo do this properly, you would have to take the databases offline, or stop
the SQL Server service.
Are you not able to use the built-in-and-highly-effective SQL Server backup
and then take those .bak files to a network location?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Nick" <andync55@.hotmail.com> wrote in message
news:OvQct%23a1FHA.2428@.tk2msftngp13.phx.gbl...
> Hi
> I have a windows 2003 server running sql. I would like to backup SQL 2000
> databases using the built in backup software to a network location.
> Could anyone tell me how i do this.
>
> Thanks
> Nick
>|||Hi
Thanks for the fast reply. Can i do that by right clicking on each databse
and selecting backup. Is that all i need to do. Is there any other sql
setting i should backup other than just the databases.
Thanks
--
Nick Comper
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:ehe21Jb1FHA.3660@.TK2MSFTNGP15.phx.gbl...
> To do this properly, you would have to take the databases offline, or stop
> the SQL Server service.
> Are you not able to use the built-in-and-highly-effective SQL Server
> backup and then take those .bak files to a network location?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "Nick" <andync55@.hotmail.com> wrote in message
> news:OvQct%23a1FHA.2428@.tk2msftngp13.phx.gbl...
>> Hi
>> I have a windows 2003 server running sql. I would like to backup SQL 2000
>> databases using the built in backup software to a network location.
>> Could anyone tell me how i do this.
>>
>> Thanks
>> Nick
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Nick" <andync55@.hotmail.com> wrote in message
news:eLJqeOb1FHA.3720@.TK2MSFTNGP14.phx.gbl...
> Hi
> Thanks for the fast reply. Can i do that by right clicking on each databse
> and selecting backup. Is that all i need to do. Is there any other sql
> setting i should backup other than just the databases.
> Thanks
> --
> Nick Comper
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:ehe21Jb1FHA.3660@.TK2MSFTNGP15.phx.gbl...
>> To do this properly, you would have to take the databases offline, or
>> stop the SQL Server service.
>> Are you not able to use the built-in-and-highly-effective SQL Server
>> backup and then take those .bak files to a network location?
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>>
>> "Nick" <andync55@.hotmail.com> wrote in message
>> news:OvQct%23a1FHA.2428@.tk2msftngp13.phx.gbl...
>> Hi
>> I have a windows 2003 server running sql. I would like to backup SQL
>> 2000 databases using the built in backup software to a network location.
>> Could anyone tell me how i do this.
>>
>> Thanks
>> Nick
>>
>|||Hi
Thanks for the fast reply. Can i do that by right clicking on each databse
and selecting backup. Is that all i need to do. Is there any other sql
setting i should backup other than just the databases.
Thanks
--
Nick Comper
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:ehe21Jb1FHA.3660@.TK2MSFTNGP15.phx.gbl...
> To do this properly, you would have to take the databases offline, or stop
> the SQL Server service.
> Are you not able to use the built-in-and-highly-effective SQL Server
> backup and then take those .bak files to a network location?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "Nick" <andync55@.hotmail.com> wrote in message
> news:OvQct%23a1FHA.2428@.tk2msftngp13.phx.gbl...
>> Hi
>> I have a windows 2003 server running sql. I would like to backup SQL 2000
>> databases using the built in backup software to a network location.
>> Could anyone tell me how i do this.
>>
>> Thanks
>> Nick
>

How can i backup sql 2000 using win 2003 backup util

Hi
I have a windows 2003 server running sql. I would like to backup SQL 2000
databases using the built in backup software to a network location.
Could anyone tell me how i do this.
Thanks
NickTo do this properly, you would have to take the databases offline, or stop
the SQL Server service.
Are you not able to use the built-in-and-highly-effective SQL Server backup
and then take those .bak files to a network location?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Nick" <andync55@.hotmail.com> wrote in message
news:OvQct%23a1FHA.2428@.tk2msftngp13.phx.gbl...
> Hi
> I have a windows 2003 server running sql. I would like to backup SQL 2000
> databases using the built in backup software to a network location.
> Could anyone tell me how i do this.
>
> Thanks
> Nick
>|||Hi
Thanks for the fast reply. Can i do that by right clicking on each databse
and selecting backup. Is that all i need to do. Is there any other sql
setting i should backup other than just the databases.
Thanks
Nick Comper
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:ehe21Jb1FHA.3660@.TK2MSFTNGP15.phx.gbl...
> To do this properly, you would have to take the databases offline, or stop
> the SQL Server service.
> Are you not able to use the built-in-and-highly-effective SQL Server
> backup and then take those .bak files to a network location?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "Nick" <andync55@.hotmail.com> wrote in message
> news:OvQct%23a1FHA.2428@.tk2msftngp13.phx.gbl...
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Nick" <andync55@.hotmail.com> wrote in message
news:eLJqeOb1FHA.3720@.TK2MSFTNGP14.phx.gbl...
> Hi
> Thanks for the fast reply. Can i do that by right clicking on each databse
> and selecting backup. Is that all i need to do. Is there any other sql
> setting i should backup other than just the databases.
> Thanks
> --
> Nick Comper
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:ehe21Jb1FHA.3660@.TK2MSFTNGP15.phx.gbl...
>|||Hi
Thanks for the fast reply. Can i do that by right clicking on each databse
and selecting backup. Is that all i need to do. Is there any other sql
setting i should backup other than just the databases.
Thanks
Nick Comper
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:ehe21Jb1FHA.3660@.TK2MSFTNGP15.phx.gbl...
> To do this properly, you would have to take the databases offline, or stop
> the SQL Server service.
> Are you not able to use the built-in-and-highly-effective SQL Server
> backup and then take those .bak files to a network location?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
> "Nick" <andync55@.hotmail.com> wrote in message
> news:OvQct%23a1FHA.2428@.tk2msftngp13.phx.gbl...
>

How can I back up to a device with out over writing the last backu

I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
database's to a device,,which works fine but it over writes the files in the
directory. The code i am using is
BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , N
AME =
N'my backup', NOSKIP , STATS = 10, NOFORMAT
Can anyone please help me with this, I tried using a mapped drive but that
does not work. Is there any way I can use a maint plan to back up to a devic
e
and not over write the last back up file? in the use this directory can I us
e
the unc?It WILL overwrite the old since you give same name to the backup file. You
must figure out another way to work for you. My backup will write to a
folder depend on what day of the week. So I always have a 7 days of backup.
hth,
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:254A39AA-C621-43B9-A12B-78AFCBF23F8F@.microsoft.com...
>I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in
> the
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD ,
NAME =
> N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a
> device
> and not over write the last back up file? in the use this directory can I
> use
> the unc?
>|||The answer to my question is yes you can use the unc path in the use this
dircetory. but I still don't know about the device over write problem.
"DAVID S" wrote:

> I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in t
he
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD ,
NAME =
> N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but tha
t
> does not work. Is there any way I can use a maint plan to back up to a dev
ice
> and not over write the last back up file? in the use this directory can I
use
> the unc?
>|||NOINIT means append and INIT means overwrite. Your statement posted will app
end.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:254A39AA-C621-43B9-A12B-78AFCBF23F8F@.microsoft.com...
>I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in t
he
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD ,
NAME =
> N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a dev
ice
> and not over write the last back up file? in the use this directory can I
use
> the unc?
>

How can I back up to a device with out over writing the last backu

I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
database's to a device,,which works fine but it over writes the files in the
directory. The code i am using is
BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME =
N'my backup', NOSKIP , STATS = 10, NOFORMAT
Can anyone please help me with this, I tried using a mapped drive but that
does not work. Is there any way I can use a maint plan to back up to a device
and not over write the last back up file? in the use this directory can I use
the unc?
It WILL overwrite the old since you give same name to the backup file. You
must figure out another way to work for you. My backup will write to a
folder depend on what day of the week. So I always have a 7 days of backup.
hth,
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:254A39AA-C621-43B9-A12B-78AFCBF23F8F@.microsoft.com...
>I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in
> the
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME =
> N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a
> device
> and not over write the last back up file? in the use this directory can I
> use
> the unc?
>
|||The answer to my question is yes you can use the unc path in the use this
dircetory. but I still don't know about the device over write problem.
"DAVID S" wrote:

> I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in the
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME =
> N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a device
> and not over write the last back up file? in the use this directory can I use
> the unc?
>
|||NOINIT means append and INIT means overwrite. Your statement posted will append.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:254A39AA-C621-43B9-A12B-78AFCBF23F8F@.microsoft.com...
>I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in the
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME =
> N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a device
> and not over write the last back up file? in the use this directory can I use
> the unc?
>

How can I back up to a device with out over writing the last backu

I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
database's to a device,,which works fine but it over writes the files in the
directory. The code i am using is
BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME = N'my backup', NOSKIP , STATS = 10, NOFORMAT
Can anyone please help me with this, I tried using a mapped drive but that
does not work. Is there any way I can use a maint plan to back up to a device
and not over write the last back up file? in the use this directory can I use
the unc?It WILL overwrite the old since you give same name to the backup file. You
must figure out another way to work for you. My backup will write to a
folder depend on what day of the week. So I always have a 7 days of backup.
hth,
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:254A39AA-C621-43B9-A12B-78AFCBF23F8F@.microsoft.com...
>I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in
> the
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a
> device
> and not over write the last back up file? in the use this directory can I
> use
> the unc?
>|||The answer to my question is yes you can use the unc path in the use this
dircetory. but I still don't know about the device over write problem.
"DAVID S" wrote:
> I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in the
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a device
> and not over write the last back up file? in the use this directory can I use
> the unc?
>|||Have you thought of using RETAINDAYS parameter in your backup statement.
Check BOL...
Thanks
GYK
"DAVID S" wrote:
> The answer to my question is yes you can use the unc path in the use this
> dircetory. but I still don't know about the device over write problem.
> "DAVID S" wrote:
> > I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> > database's to a device,,which works fine but it over writes the files in the
> > directory. The code i am using is
> >
> > BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => > N'my backup', NOSKIP , STATS = 10, NOFORMAT
> >
> > Can anyone please help me with this, I tried using a mapped drive but that
> > does not work. Is there any way I can use a maint plan to back up to a device
> > and not over write the last back up file? in the use this directory can I use
> > the unc?
> >
> >|||Yes and it did not work.. but thank you for responding
"GYK" wrote:
> Have you thought of using RETAINDAYS parameter in your backup statement.
> Check BOL...
> Thanks
> GYK
> "DAVID S" wrote:
> > The answer to my question is yes you can use the unc path in the use this
> > dircetory. but I still don't know about the device over write problem.
> >
> > "DAVID S" wrote:
> >
> > > I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> > > database's to a device,,which works fine but it over writes the files in the
> > > directory. The code i am using is
> > >
> > > BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => > > N'my backup', NOSKIP , STATS = 10, NOFORMAT
> > >
> > > Can anyone please help me with this, I tried using a mapped drive but that
> > > does not work. Is there any way I can use a maint plan to back up to a device
> > > and not over write the last back up file? in the use this directory can I use
> > > the unc?
> > >
> > >|||Try removing the name = N'my backup'... leave it blank and try...
Thanks
GYK
"DAVID S" wrote:
> Yes and it did not work.. but thank you for responding
> "GYK" wrote:
> > Have you thought of using RETAINDAYS parameter in your backup statement.
> > Check BOL...
> >
> > Thanks
> > GYK
> >
> > "DAVID S" wrote:
> >
> > > The answer to my question is yes you can use the unc path in the use this
> > > dircetory. but I still don't know about the device over write problem.
> > >
> > > "DAVID S" wrote:
> > >
> > > > I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> > > > database's to a device,,which works fine but it over writes the files in the
> > > > directory. The code i am using is
> > > >
> > > > BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => > > > N'my backup', NOSKIP , STATS = 10, NOFORMAT
> > > >
> > > > Can anyone please help me with this, I tried using a mapped drive but that
> > > > does not work. Is there any way I can use a maint plan to back up to a device
> > > > and not over write the last back up file? in the use this directory can I use
> > > > the unc?
> > > >
> > > >|||NOINIT means append and INIT means overwrite. Your statement posted will append.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DAVID S" <DAVIDS@.discussions.microsoft.com> wrote in message
news:254A39AA-C621-43B9-A12B-78AFCBF23F8F@.microsoft.com...
>I am using sql2000 sp3 on windows 2003 server. I am trying to back up my
> database's to a device,,which works fine but it over writes the files in the
> directory. The code i am using is
> BACKUP DATABASE [mydb] TO [mydbbackup] WITH NOINIT , NOUNLOAD , NAME => N'my backup', NOSKIP , STATS = 10, NOFORMAT
> Can anyone please help me with this, I tried using a mapped drive but that
> does not work. Is there any way I can use a maint plan to back up to a device
> and not over write the last back up file? in the use this directory can I use
> the unc?
>

How can I access SQL server from SCO Unix?

We are running SCO Unix 5.0.5. We need a command line sql client that can connect to a MS SQL server running on a windows server. Can someone point me in the right direction? I don't want to write a sql client. I just want a command line sql client binary that is ready to work.

I want to do something like this in a unix shell script:

# sql -s 10.1.2.3 -u username -p password -f sqlcommandsinafile.txt -o sqlresults.txt

Any help would be appreciated....

I am not aware of such a cmd line tool on unix. To achieve what you want, you would need to get a hold of a 3rd party unix ODBC driver for SQL server. There is an odbcsql sample that ships with MDAC SDK, you can download the sample and port it to run on Unix.

Hope this helps.

sql

How can I access SQL server from SCO Unix?

We are running SCO Unix 5.0.5. We need a command line sql client that can connect to a MS SQL server running on a windows server. Can someone point me in the right direction? I don't want to write a sql client. I just want a command line sql client binary that is ready to work.

I want to do something like this in a unix shell script:

# sql -s 10.1.2.3 -u username -p password -f sqlcommandsinafile.txt -o sqlresults.txt

Any help would be appreciated....

I am not aware of such a cmd line tool on unix. To achieve what you want, you would need to get a hold of a 3rd party unix ODBC driver for SQL server. There is an odbcsql sample that ships with MDAC SDK, you can download the sample and port it to run on Unix.

Hope this helps.

How can I access data to SQL server 2005 using Windows application,ADO.net and .Net remoting.

How can I access data to SQL server 2005 using Windows form application,ADO.net and .Net remoting?

Can anybody help me? please...

This question is too vague. Do you have a specific issue or question?|||

Here is one place to start:

http://www.411asp.net/home/tutorial/howto/applicat

I suggest that you go to your local bookstore or library and look over the options. Or Google?

"create .NET application"

|||

Deepak Kapoor wrote:

This question is too vague. Do you have a specific issue or question?

Hi ! Deepak Kapoor

I am a C# beginner, I have to write some code using windows application,that's need to INSERT,UPDATE,SELECT and DELETE data to sql server using ADO.net and .net remoting...

1.The client application include 1 dataGridView and 4 buttons(Add,Delete,Edit and Load).

2.The server application include 1label and 1 button to start server application.

3.The remote object.

Here are my questions.

I already wrote for the Load button of the client application.But, I dont know how to program for the remaining buttons.And I want to access data directly into the dataGridView.If you know how to do,please post some explaination and give me some example code.

This is my remote object.

public class AuthorList : MarshalByRefObject

{

private static string connectionString = @."server = BMSTU\KTS ;database = kts;uid=sa;pwd=";

public DataTable GetAuthors()

{

string SQL = "SELECT * FROM Author";

// Create ADO.NET objects to execute the DB query.

SqlConnection conn = new SqlConnection(connectionString);

SqlCommand cmd = new SqlCommand(SQL, conn);

SqlDataAdapter adapter = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

// Execute the command.

try

{

conn.Open();

adapter.Fill(ds, "Author");

}

catch (Exception err)

{

Console.WriteLine(err.ToString());

}

finally

{

conn.Close();

}

// Return the first DataTable in the DataSet to the caller.

return ds.Tables["Author"];

}

// This method allows you to verify that the object is running remotely.

public string GetHostLocation()

{

return AppDomain.CurrentDomain.FriendlyName;

}

}

This is the Server application.

private void button1_Click(object sender, EventArgs e)

{

HttpChannel myChannel = new HttpChannel(8080);

ChannelServices.RegisterChannel(myChannel);

RemotingConfiguration.RegisterWellKnownServiceType(typeof(BookServer.AuthorList),

"AuthorList", WellKnownObjectMode.Singleton);

label1.Text = "Server Started";

button1.Enabled = false;

}

This is the Client application

private void btnLoad_Click(object sender, EventArgs e)

{

AuthorList atlst = (AuthorList)Activator.GetObject(typeof(AuthorList),

"http://localhost:8080/AuthorList", WellKnownObjectMode.Singleton);

dataGridView2.DataSource = null;

dataGridView2.DataSource = atlst.GetAuthors();

}

If you know how to program for the btnAdd,btnEdit and btnDelete of the Client application.And how to program in server and remote object.I am hoping anybody's help.

Best regards ,

thanks,

WhoAmI?

|||hmmm, can anyone help me?

How automatically process a Cube periodically

Good morning,

I have create a solution with two cubes, but I want that these cubes process automatically, with a batch or a windows task.

But I don't find how to do this. Do I need to create a script or something like that.

I'm totally lost.

Thanks for your help,

You can use SQL Server Integration Services (search for Processing Objects Using Integration Services in BOL), or you could also Analysis Managment Objects (AMO).
|||

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

|||

Titou wrote:

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

I forgot to note that i work with sql server and analysis services 2005

|||In BI Development Studio, create a new SSIS task. In the Control Flow tab, first add a connection manager for your Analysis Services database (bottom tab, right-click), then drag an Analysis Services Processing Task from the toolbar on the left (the tab may be minimized). In the task, set which objects you want processed.

Save locally, and then go to the file menu and do a Save a copy of... And save it to your SQL Server database that Analysis Services is sitting on.

Go to Management studio and connect to the database (not Analysis Services). Go to the SQL Server Agent and right-click on jobs. Add a new job. In the job type, select SSIS job, select the SSIS package that you just created, and voila! You have a job on the database that you can now set to occur periodically.

It's a little confusing at first, but once it gets going, it's pretty simple. After your first one, you'll probably want to go back and add logging, too...

-Doug
|||

I success in the creation of the SSIS task, but when i go to Sql Server, I can't find my file an I can't had or browse to find it, could you help me?

Thanks

|||

Many options are available. Two immediately come to mind. Both involve scripting. When you have the processing dialog box open (just before you process) you will notice a box at the top that says "Script". It will take whatever you are about to do for processing and create an XMLA script a background window.

Once you have the script then:

1) Create a SQL Agent job and a step within it. There is a new option in the step that allows it to run an Analysis Services Command -- this is the XMLA script that you created above. Simply paste it into the step and then schedule the SQL Agent job as needed.

2) Create an SSIS package and select an Analysis Services Execute DDL task. Insert the XMLA script into it and it will execute it as a step in the SSIS package.

Alternatively, you could create an SSIS package and use the Analsyis Services Processing task and specify what object you wish to process. That works well also.

Finally, coming in WR2 of the Samples MSI in April will be a new utility called ascmd (which is patterened after sqlcmd) that allows you to execute XMLA scripts (and MDX queries) from the command line. If you are interested in getting a pre-release version of it, contact me (dwickert@.microsoft.com) and I will point you to the right folks.

Hope that helps.

_-_-_ Dave

|||

Hi.

Thanks, DWBI_Doug! Worked perfectly!

Regards

Kjetil

|||Thank You DWBI_Doug, You saved my day. i ow you one.

How automatically process a Cube periodically

Good morning,

I have create a solution with two cubes, but I want that these cubes process automatically, with a batch or a windows task.

But I don't find how to do this. Do I need to create a script or something like that.

I'm totally lost.

Thanks for your help,

You can use SQL Server Integration Services (search for Processing

Objects Using Integration Services in BOL), or you could also Analysis

Managment Objects (AMO).|||

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

|||

Titou wrote:

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

I forgot to note that i work with sql server and analysis services 2005

|||In BI Development Studio, create a new SSIS task. In the Control Flow tab, first add a connection manager for your Analysis Services database (bottom tab, right-click), then drag an Analysis Services Processing Task from the toolbar on the left (the tab may be minimized). In the task, set which objects you want processed.

Save locally, and then go to the file menu and do a Save a copy of... And save it to your SQL Server database that Analysis Services is sitting on.

Go to Management studio and connect to the database (not Analysis Services). Go to the SQL Server Agent and right-click on jobs. Add a new job. In the job type, select SSIS job, select the SSIS package that you just created, and voila! You have a job on the database that you can now set to occur periodically.

It's a little confusing at first, but once it gets going, it's pretty simple. After your first one, you'll probably want to go back and add logging, too...

-Doug|||

I success in the creation of the SSIS task, but when i go to Sql Server, I can't find my file an I can't had or browse to find it, could you help me?

Thanks

|||

Many options are available. Two immediately come to mind. Both involve scripting. When you have the processing dialog box open (just before you process) you will notice a box at the top that says "Script". It will take whatever you are about to do for processing and create an XMLA script a background window.

Once you have the script then:

1) Create a SQL Agent job and a step within it. There is a new option in the step that allows it to run an Analysis Services Command -- this is the XMLA script that you created above. Simply paste it into the step and then schedule the SQL Agent job as needed.

2) Create an SSIS package and select an Analysis Services Execute DDL task. Insert the XMLA script into it and it will execute it as a step in the SSIS package.

Alternatively, you could create an SSIS package and use the Analsyis Services Processing task and specify what object you wish to process. That works well also.

Finally, coming in WR2 of the Samples MSI in April will be a new utility called ascmd (which is patterened after sqlcmd) that allows you to execute XMLA scripts (and MDX queries) from the command line. If you are interested in getting a pre-release version of it, contact me (dwickert@.microsoft.com) and I will point you to the right folks.

Hope that helps.

_-_-_ Dave

|||

Hi.

Thanks, DWBI_Doug! Worked perfectly!

Regards

Kjetil

How automatically process a Cube periodically

Good morning,

I have create a solution with two cubes, but I want that these cubes process automatically, with a batch or a windows task.

But I don't find how to do this. Do I need to create a script or something like that.

I'm totally lost.

Thanks for your help,

You can use SQL Server Integration Services (search for Processing Objects Using Integration Services in BOL), or you could also Analysis Managment Objects (AMO).
|||

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

|||

Titou wrote:

I see this in another article, but I don't found Analysis Services Processing Task.

Is it install with sql server 2005 or not?

Do you have an example that I can see, please or some indications?

Thanks,

I forgot to note that i work with sql server and analysis services 2005

|||In BI Development Studio, create a new SSIS task. In the Control Flow tab, first add a connection manager for your Analysis Services database (bottom tab, right-click), then drag an Analysis Services Processing Task from the toolbar on the left (the tab may be minimized). In the task, set which objects you want processed.

Save locally, and then go to the file menu and do a Save a copy of... And save it to your SQL Server database that Analysis Services is sitting on.

Go to Management studio and connect to the database (not Analysis Services). Go to the SQL Server Agent and right-click on jobs. Add a new job. In the job type, select SSIS job, select the SSIS package that you just created, and voila! You have a job on the database that you can now set to occur periodically.

It's a little confusing at first, but once it gets going, it's pretty simple. After your first one, you'll probably want to go back and add logging, too...

-Doug
|||

I success in the creation of the SSIS task, but when i go to Sql Server, I can't find my file an I can't had or browse to find it, could you help me?

Thanks

|||

Many options are available. Two immediately come to mind. Both involve scripting. When you have the processing dialog box open (just before you process) you will notice a box at the top that says "Script". It will take whatever you are about to do for processing and create an XMLA script a background window.

Once you have the script then:

1) Create a SQL Agent job and a step within it. There is a new option in the step that allows it to run an Analysis Services Command -- this is the XMLA script that you created above. Simply paste it into the step and then schedule the SQL Agent job as needed.

2) Create an SSIS package and select an Analysis Services Execute DDL task. Insert the XMLA script into it and it will execute it as a step in the SSIS package.

Alternatively, you could create an SSIS package and use the Analsyis Services Processing task and specify what object you wish to process. That works well also.

Finally, coming in WR2 of the Samples MSI in April will be a new utility called ascmd (which is patterened after sqlcmd) that allows you to execute XMLA scripts (and MDX queries) from the command line. If you are interested in getting a pre-release version of it, contact me (dwickert@.microsoft.com) and I will point you to the right folks.

Hope that helps.

_-_-_ Dave

|||

Hi.

Thanks, DWBI_Doug! Worked perfectly!

Regards

Kjetil

|||Thank You DWBI_Doug, You saved my day. i ow you one.

How am I protecting my Database from freign people at my network

as well particular tables in my database should be acceible only for users supply special U/N & PWD within my program

(Windows application - VB.NET)

thanks for referring

You better to have a security policy for your ENV. SQL Server follows two level security architecture. One at server level (LOGIN) and the other at Databaes level (User). You can restrict the permission on objects. you can give access to table(i would always prefer to create view or sp to access table instead of giving direct select permission on table) to individual user or role.

http://msdn2.microsoft.com/en-us/library/aa905172(SQL.80).aspx

http://www.microsoft.com/technet/community/chats/trans/sql/sql0522.mspx

Madhu

Hotfix Installation failed on named Instance on a SQL-Server-2000 Cluster

Hi all,
I have a windows 2003 cluster
with sql-server 2000 sp3
and a named instance.
I wanted to installation the hotfix ..859, but the installation failed
and I got the error:
"The logged on account does not have administrator privileges on all
possible owner nodes of the selected SQL Server configuration.
Please log on using an account that has administrator privileges on all
possible owner nodes and then run Hotfix Installer again."
I've checked different things.
My account has the correct rights, the RPC service is running, DNS
works fine ...
I have no idea what to do!
Can someone help?
Greetings
Susn
Are you running the hotfix from the controlling node? Also, you may have to
reboot each node, before the hotfix will install.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
<liebesusn@.web.de> wrote in message
news:1106919750.693602.235970@.f14g2000cwb.googlegr oups.com...
> Hi all,
> I have a windows 2003 cluster
> with sql-server 2000 sp3
> and a named instance.
> I wanted to installation the hotfix ..859, but the installation failed
> and I got the error:
> "The logged on account does not have administrator privileges on all
> possible owner nodes of the selected SQL Server configuration.
> Please log on using an account that has administrator privileges on all
> possible owner nodes and then run Hotfix Installer again."
> I've checked different things.
> My account has the correct rights, the RPC service is running, DNS
> works fine ...
> I have no idea what to do!
> Can someone help?
> Greetings
> Susn
>
|||Hi Rod,
yes, the hotfix was running from the controlling node and both nodes
was rebooted.
Any other idea?
Greetings Susn
|||No, that about does it for me, sorry!
Rod
"Susn" <liebesusn@.web.de> wrote in message
news:1107160932.634056.6880@.c13g2000cwb.googlegrou ps.com...
> Hi Rod,
> yes, the hotfix was running from the controlling node and both nodes
> was rebooted.
> Any other idea?
> Greetings Susn
>
|||Hi Susn,
Just wondering if you were able to install the hotfix. I would recommend you to log into both the nodes of the cluster with the startup account of the clustered SQL Server service (this account is a doman account and
should have all the required rights). Then start the hotfix installation on the node where SQL Server instance is currently running.
Keep up updated. If it fails, then please post the log for the hotfix failure.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx