Hello,
we use Windows Authentification with SQL Server 2005 but we want our users
to access to the database only with an application. We don't want our users
to access to the database with an other application.
What are the possibilities ? Does SQL Server recognize an application with a
signature or something like that ?
Thanks
Best regardsCheck in Books On Line about the use of an 'Application Role'.
An 'Application Role' is a special type of login that may work for your
situation.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Jojonews" <Jojonews@.discussions.microsoft.com> wrote in message
news:46345D65-7404-40EE-BECE-BED51AEC45B1@.microsoft.com...
> Hello,
> we use Windows Authentification with SQL Server 2005 but we want our users
> to access to the database only with an application. We don't want our
> users
> to access to the database with an other application.
> What are the possibilities ? Does SQL Server recognize an application with
> a
> signature or something like that ?
> Thanks
> Best regardssql
Showing posts with label windows. Show all posts
Showing posts with label windows. Show all posts
Friday, March 30, 2012
How to attach an .MDF file to another server?
Hi all
I am having trouble moving an .mdf file from a dev machine to a production machine.
On the dev machine(windows xp sp2 login <MyName>) I have an SSE instance - part of VisualStudio installation.
on the production machine I have only one full version SS instance called "PROD"(windows server 2k3, login Administrator) I do have SSMS installed too.
I create a website in VS on my dev machine. C:\Websites\Website1
I add to App_Data a new file: DB1.mdf
I add a couple of tables to DB1.mdf and maybe other objects etc. - all dbo.
Then I detach DB1.mdf and physically copy the file (without the .ldf as suggested in books online) via tha LAN.
from: C:\Websites\Website1\App_Data\DB1.mdf(dev machine)
to: C:\DB1.mdf (production machine)
I then try to attach C:\DB1.mdf to PROD and I get an error. The server is looking for a db by the name of the original path on the dev machine C:\Websites\Website1\App_Data\DB1.mdf There seems to be no way to rename the db.-not in VS before detaching it, not on PROD in the GUI to attach.
Just for kicks, I created the same folders on the production machine, so the file would have the same physical path as its name(which I still cannot change). C:\Websites\Website1\App_Data\DB1.mdf I even pasted the original .ldf file. This time it worked. I was able to attach it.
What is up with this? Is an .mdf file for ever stuck with the name of the path where it was first created?
This seems to be a most common scenario, even though I am not deploying a whole website.
Are we always supposed to execute our own script?
How are you reattaching the file ?You should be able to use the command:
CREATE DATABASE database_name
ON
(name = logical_file_name,
filename = 'new file location')
FOR ATTACH
You'll need to know the logical_file_name that the mdf file uses. Find that out by running this command in the database before detaching:
select name from sysfiles where filename like '%.mdf'
|||
If you right click on the databases folder in Object Explorer in SSMS and select Attach... you get a UI to locate the .mdf file. The UI looks for the other files in database (.ndf or .ldf) in the locations specified in the .mdf file. If it doesn't find them there, it displays an error message for the files it can't find.
You can change the location where it is looking for the other files by editing the "Current File Path" in the lower grid. You can also remove the .ldf files from the grid (so it won't try to attach them) by selecting them in the grid and clicking on the Remove button.
Hope this helps,
Steve
|||Thanks to both of you.
Both ways work now. I can't even duplicate the issue, and I remember I struggled for a while prior to posting a few days ago. It just didn't like that file name. I swear there is a voodoo ghost on the network!
Steven, I also played with some test UDFs and TVFs written in c#. I right-click deployed the assembly in visual studio. The test was to see what all I needed to do when I reattach the .mdf file. Well the functions work on the new machine just like that. So where is the .net assembly? Is the .dll embedded in the .mdf file? Because that is all I transferred.
Carl
Monday, March 26, 2012
How to apply sp4 to multiple instances that have different sp leve
I need to apply sp4 for SqlServer 2000 to the following instances all runnin
g
on the same server. The server is running Windows 2000.
SERVER Name: ABC01DB
SqlServer Instances follow:
Default 8.00.534 SP2 Developer Edition
DEV 8.00.760 SP3 Developer Edition
ABCDEV_APP01 (*) 8.00.194 RTM Developer Edition
ABCDEV_LT01 (*) 8.00.194 RTM Developer Edition
ABCDEV_LT02 (*) 8.00.194 RTM Developer Edition
ABCDEV_QA01 (*) 8.00.194 RTM Developer Edition
ABC_MGR 8.00.760 SP3 Developer Edition
Questions:
1) Do I need to apply any service packs other than sp4 to any of them prior
to applying sp4.
2) Is there any way to apply sp4 to multiple instances simultaneously or
must I apply sp4 separately for each instance.
3) Any suggestions or comments regarding the steps to simplify applying sp4
to all of the above instances.I proceeded with the upgrade and simply applied the sp4 to each instance,
starting with those which had no service packs first, (RTM). Then, I applie
d
it to the Default which was at sp2, and finally to those at sp3.
It all works.
"theWizard1" wrote:
> I need to apply sp4 for SqlServer 2000 to the following instances all runn
ing
> on the same server. The server is running Windows 2000.
> SERVER Name: ABC01DB
> SqlServer Instances follow:
> Default 8.00.534 SP2 Developer Edition
> DEV 8.00.760 SP3 Developer Edition
> ABCDEV_APP01 (*) 8.00.194 RTM Developer Edition
> ABCDEV_LT01 (*) 8.00.194 RTM Developer Edition
> ABCDEV_LT02 (*) 8.00.194 RTM Developer Edition
> ABCDEV_QA01 (*) 8.00.194 RTM Developer Edition
> ABC_MGR 8.00.760 SP3 Developer Edition
> Questions:
> 1) Do I need to apply any service packs other than sp4 to any of them pri
or
> to applying sp4.
> 2) Is there any way to apply sp4 to multiple instances simultaneously or
> must I apply sp4 separately for each instance.
> 3) Any suggestions or comments regarding the steps to simplify applying sp
4
> to all of the above instances.
g
on the same server. The server is running Windows 2000.
SERVER Name: ABC01DB
SqlServer Instances follow:
Default 8.00.534 SP2 Developer Edition
DEV 8.00.760 SP3 Developer Edition
ABCDEV_APP01 (*) 8.00.194 RTM Developer Edition
ABCDEV_LT01 (*) 8.00.194 RTM Developer Edition
ABCDEV_LT02 (*) 8.00.194 RTM Developer Edition
ABCDEV_QA01 (*) 8.00.194 RTM Developer Edition
ABC_MGR 8.00.760 SP3 Developer Edition
Questions:
1) Do I need to apply any service packs other than sp4 to any of them prior
to applying sp4.
2) Is there any way to apply sp4 to multiple instances simultaneously or
must I apply sp4 separately for each instance.
3) Any suggestions or comments regarding the steps to simplify applying sp4
to all of the above instances.I proceeded with the upgrade and simply applied the sp4 to each instance,
starting with those which had no service packs first, (RTM). Then, I applie
d
it to the Default which was at sp2, and finally to those at sp3.
It all works.
"theWizard1" wrote:
> I need to apply sp4 for SqlServer 2000 to the following instances all runn
ing
> on the same server. The server is running Windows 2000.
> SERVER Name: ABC01DB
> SqlServer Instances follow:
> Default 8.00.534 SP2 Developer Edition
> DEV 8.00.760 SP3 Developer Edition
> ABCDEV_APP01 (*) 8.00.194 RTM Developer Edition
> ABCDEV_LT01 (*) 8.00.194 RTM Developer Edition
> ABCDEV_LT02 (*) 8.00.194 RTM Developer Edition
> ABCDEV_QA01 (*) 8.00.194 RTM Developer Edition
> ABC_MGR 8.00.760 SP3 Developer Edition
> Questions:
> 1) Do I need to apply any service packs other than sp4 to any of them pri
or
> to applying sp4.
> 2) Is there any way to apply sp4 to multiple instances simultaneously or
> must I apply sp4 separately for each instance.
> 3) Any suggestions or comments regarding the steps to simplify applying sp
4
> to all of the above instances.
How to apply sp4 to multiple instances that have different sp leve
I need to apply sp4 for SqlServer 2000 to the following instances all running
on the same server. The server is running Windows 2000.
SERVER Name: ABC01DB
SqlServer Instances follow:
Default 8.00.534 SP2 Developer Edition
DEV 8.00.760 SP3 Developer Edition
ABCDEV_APP01 (*) 8.00.194 RTM Developer Edition
ABCDEV_LT01 (*) 8.00.194 RTM Developer Edition
ABCDEV_LT02 (*) 8.00.194 RTM Developer Edition
ABCDEV_QA01 (*) 8.00.194 RTM Developer Edition
ABC_MGR 8.00.760 SP3 Developer Edition
Questions:
1) Do I need to apply any service packs other than sp4 to any of them prior
to applying sp4.
2) Is there any way to apply sp4 to multiple instances simultaneously or
must I apply sp4 separately for each instance.
3) Any suggestions or comments regarding the steps to simplify applying sp4
to all of the above instances.I proceeded with the upgrade and simply applied the sp4 to each instance,
starting with those which had no service packs first, (RTM). Then, I applied
it to the Default which was at sp2, and finally to those at sp3.
It all works.
"theWizard1" wrote:
> I need to apply sp4 for SqlServer 2000 to the following instances all running
> on the same server. The server is running Windows 2000.
> SERVER Name: ABC01DB
> SqlServer Instances follow:
> Default 8.00.534 SP2 Developer Edition
> DEV 8.00.760 SP3 Developer Edition
> ABCDEV_APP01 (*) 8.00.194 RTM Developer Edition
> ABCDEV_LT01 (*) 8.00.194 RTM Developer Edition
> ABCDEV_LT02 (*) 8.00.194 RTM Developer Edition
> ABCDEV_QA01 (*) 8.00.194 RTM Developer Edition
> ABC_MGR 8.00.760 SP3 Developer Edition
> Questions:
> 1) Do I need to apply any service packs other than sp4 to any of them prior
> to applying sp4.
> 2) Is there any way to apply sp4 to multiple instances simultaneously or
> must I apply sp4 separately for each instance.
> 3) Any suggestions or comments regarding the steps to simplify applying sp4
> to all of the above instances.sql
on the same server. The server is running Windows 2000.
SERVER Name: ABC01DB
SqlServer Instances follow:
Default 8.00.534 SP2 Developer Edition
DEV 8.00.760 SP3 Developer Edition
ABCDEV_APP01 (*) 8.00.194 RTM Developer Edition
ABCDEV_LT01 (*) 8.00.194 RTM Developer Edition
ABCDEV_LT02 (*) 8.00.194 RTM Developer Edition
ABCDEV_QA01 (*) 8.00.194 RTM Developer Edition
ABC_MGR 8.00.760 SP3 Developer Edition
Questions:
1) Do I need to apply any service packs other than sp4 to any of them prior
to applying sp4.
2) Is there any way to apply sp4 to multiple instances simultaneously or
must I apply sp4 separately for each instance.
3) Any suggestions or comments regarding the steps to simplify applying sp4
to all of the above instances.I proceeded with the upgrade and simply applied the sp4 to each instance,
starting with those which had no service packs first, (RTM). Then, I applied
it to the Default which was at sp2, and finally to those at sp3.
It all works.
"theWizard1" wrote:
> I need to apply sp4 for SqlServer 2000 to the following instances all running
> on the same server. The server is running Windows 2000.
> SERVER Name: ABC01DB
> SqlServer Instances follow:
> Default 8.00.534 SP2 Developer Edition
> DEV 8.00.760 SP3 Developer Edition
> ABCDEV_APP01 (*) 8.00.194 RTM Developer Edition
> ABCDEV_LT01 (*) 8.00.194 RTM Developer Edition
> ABCDEV_LT02 (*) 8.00.194 RTM Developer Edition
> ABCDEV_QA01 (*) 8.00.194 RTM Developer Edition
> ABC_MGR 8.00.760 SP3 Developer Edition
> Questions:
> 1) Do I need to apply any service packs other than sp4 to any of them prior
> to applying sp4.
> 2) Is there any way to apply sp4 to multiple instances simultaneously or
> must I apply sp4 separately for each instance.
> 3) Any suggestions or comments regarding the steps to simplify applying sp4
> to all of the above instances.sql
how to append windows login name to table name
hi,
I want to append the windows login name to the table that i created in the stored procedure, Is there any command , can any one help.
Advance thanksIf I understand it correctly, you want to create a table using a stored procedure and the name of the table will contain the Windows login name of the use. Is this correct? Are you calling the stored procedure from TSQL or through a .NET application? Can you provide more details?|||Hi
declare @.sql nvarchar(100)
set @.sql= 'Create table [Test_' + SYSTEM_USER +']'
exec SP_executeSQL @.sql
this may work check it but it will give u the user name if only you are logged in with windows autintication|||HI ALL
I WANTED TO CREATE A TEMPOARARY TABLE UNIQUELY WHEN DIFFERENT CLIENTS HITS THE SERVER AND EXECUTE THE SAME PROCEDURE.FOR THAT I USED HOST_NAME FOR CREATING THE TEMPORARY TABLE.IT CREATED THE TABLE APPENDING WITH HOST_NAME
THANKS|||
I want to append the windows login name to the table that i created in the stored procedure, Is there any command , can any one help.
Advance thanksIf I understand it correctly, you want to create a table using a stored procedure and the name of the table will contain the Windows login name of the use. Is this correct? Are you calling the stored procedure from TSQL or through a .NET application? Can you provide more details?|||Hi
declare @.sql nvarchar(100)
set @.sql= 'Create table [Test_' + SYSTEM_USER +']'
exec SP_executeSQL @.sql
this may work check it but it will give u the user name if only you are logged in with windows autintication|||HI ALL
I WANTED TO CREATE A TEMPOARARY TABLE UNIQUELY WHEN DIFFERENT CLIENTS HITS THE SERVER AND EXECUTE THE SAME PROCEDURE.FOR THAT I USED HOST_NAME FOR CREATING THE TEMPORARY TABLE.IT CREATED THE TABLE APPENDING WITH HOST_NAME
THANKS|||
I don't know the whole story but it sounds like you need to keep similar data unique to a specific user.
I've done this by creating one table that has a UserID field. Then you can easily manage 1 table by passing the UserID into the SP. This works well for inserts as well as selects.
For example:
Field1 Field2 UserID
111 222 JohnDoe
333 444 JohnDoe
555 666 JoeSchmoe
777 888 JoeSchmoe
THis has worked well for me even with a large number of users and each having a large number of "User-SPecific" records.
Wednesday, March 21, 2012
how to allow anonymous login to rep services on local machine ?
Hi,
I cant seem to allow reporting services on 2003 SBS to accept anonymous
logon (i.e im always prompted for user/pass from windows).
I added EVERYONE and ANONYMOUS LOGON with full control to INETPUB and
C:\program files\Microsoft SQL server dirs and made sure these settings
replaced all child dirs security i.e cascaded down.
Its a stand alone machine for demos so im not worried about security.
Can someone help ?
Thanks
Scottok sorted it using the IIS dir security options.
scott
I cant seem to allow reporting services on 2003 SBS to accept anonymous
logon (i.e im always prompted for user/pass from windows).
I added EVERYONE and ANONYMOUS LOGON with full control to INETPUB and
C:\program files\Microsoft SQL server dirs and made sure these settings
replaced all child dirs security i.e cascaded down.
Its a stand alone machine for demos so im not worried about security.
Can someone help ?
Thanks
Scottok sorted it using the IIS dir security options.
scott
Monday, March 19, 2012
How to add sp to SQL 2005 cluster?
Hey everyone,
We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?
TIA,
Clayton
It is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>
|||Hey Jason,
Thanks for the reply.
So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.
That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.
Clayton
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> It is documented in this help file.
> http://go.microsoft.com/fwlink/?LinkId=71757
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
>
|||SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.
Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
> Hey Jason,
> Thanks for the reply.
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
> Clayton
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>
|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
>
We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?
TIA,
Clayton
It is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>
|||Hey Jason,
Thanks for the reply.
So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.
That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.
Clayton
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> It is documented in this help file.
> http://go.microsoft.com/fwlink/?LinkId=71757
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
>
|||SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.
Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
> Hey Jason,
> Thanks for the reply.
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
> Clayton
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>
|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
>
How to add sp to SQL 2005 cluster?
Hey everyone,
We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?
TIA,
Clayton
It is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>
|||Hey Jason,
Thanks for the reply.
So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.
That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.
Clayton
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> It is documented in this help file.
> http://go.microsoft.com/fwlink/?LinkId=71757
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
>
|||SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.
Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
> Hey Jason,
> Thanks for the reply.
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
> Clayton
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>
|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
>
We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?
TIA,
Clayton
It is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>
|||Hey Jason,
Thanks for the reply.
So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.
That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.
Clayton
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> It is documented in this help file.
> http://go.microsoft.com/fwlink/?LinkId=71757
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
>
|||SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.
Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
> Hey Jason,
> Thanks for the reply.
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
> Clayton
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>
|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
>
How to add sp to SQL 2005 cluster?
Hey everyone,
We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?
TIA,
Clayton
It is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>
|||Hey Jason,
Thanks for the reply.
So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.
That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.
Clayton
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> It is documented in this help file.
> http://go.microsoft.com/fwlink/?LinkId=71757
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
>
|||SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.
Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
> Hey Jason,
> Thanks for the reply.
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
> Clayton
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>
|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
>
|||go Microsft or the microft developer blogs and you'll find plenty
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>
|||Not really that different from applying the service pack on a standalone. You
can just run the SP executable. The setup is cluster aware so it'll figure
out the nodes where the files need to be applied.
Linchi
"Knowledgy" wrote:
> go Microsft or the microft developer blogs and you'll find plenty
> --
> Sincerely,
> John K
> Knowledgy Consulting
> http://knowledgy.org/
> Atlanta's Business Intelligence and Data Warehouse Experts
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
>
>
We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?
TIA,
Clayton
It is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>
|||Hey Jason,
Thanks for the reply.
So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.
That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.
Clayton
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> It is documented in this help file.
> http://go.microsoft.com/fwlink/?LinkId=71757
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
>
|||SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.
Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
> Hey Jason,
> Thanks for the reply.
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
> Clayton
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>
|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com ...
>
|||go Microsft or the microft developer blogs and you'll find plenty
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>
|||Not really that different from applying the service pack on a standalone. You
can just run the SP executable. The setup is cluster aware so it'll figure
out the nodes where the files need to be applied.
Linchi
"Knowledgy" wrote:
> go Microsft or the microft developer blogs and you'll find plenty
> --
> Sincerely,
> John K
> Knowledgy Consulting
> http://knowledgy.org/
> Atlanta's Business Intelligence and Data Warehouse Experts
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com ...
>
>
How to add sp to SQL 2005 cluster?
Hey everyone,
We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?
TIA,
ClaytonIt is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/.../1/Default.aspx
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>|||Hey Jason,
Thanks for the reply.
So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.
That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.
Clayton
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> It is documented in this help file.
> http://go.microsoft.com/fwlink/?LinkId=71757
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/.../1/Default.aspx
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>|||SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.
Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
> Hey Jason,
> Thanks for the reply.
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
> Clayton
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
>
We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?
TIA,
ClaytonIt is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/.../1/Default.aspx
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>|||Hey Jason,
Thanks for the reply.
So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.
That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.
Clayton
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> It is documented in this help file.
> http://go.microsoft.com/fwlink/?LinkId=71757
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/.../1/Default.aspx
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>|||SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.
Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
> Hey Jason,
> Thanks for the reply.
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
> Clayton
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
>
How to add sp to SQL 2005 cluster?
Hey everyone,
We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?
TIA,
ClaytonIt is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>|||Hey Jason,
Thanks for the reply.
So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.
That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.
Clayton
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> It is documented in this help file.
> http://go.microsoft.com/fwlink/?LinkId=71757
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> Hey everyone,
>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>> install a service pack for SQL 2005.
>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>
>> TIA,
>>
>> Clayton
>|||SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.
Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
> Hey Jason,
> Thanks for the reply.
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
> Clayton
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>> It is documented in this help file.
>> http://go.microsoft.com/fwlink/?LinkId=71757
>>
>> --
>> Jason Massie
>> Web: http://statisticsio.com
>> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> Hey everyone,
>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>> install a service pack for SQL 2005.
>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>
>> TIA,
>>
>> Clayton
>>
>|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
>> Hey Jason,
>> Thanks for the reply.
>> So from reading the below link it sounds like I don't have to stop the
>> cluster service or anything. Just put the service pack CD in and go for
>> it.
>> That's not the way it worked when I had to update Exchange 2003 to sp2.
>> I had to pause each node and stop the cluster service before I could
>> install the sp.
>>
>> Clayton
>>
>> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
>> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>> It is documented in this help file.
>> http://go.microsoft.com/fwlink/?LinkId=71757
>>
>> --
>> Jason Massie
>> Web: http://statisticsio.com
>> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> Hey everyone,
>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>> install a service pack for SQL 2005.
>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>
>> TIA,
>>
>> Clayton
>>
>>
>|||go Microsft or the microft developer blogs and you'll find plenty
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>|||Not really that different from applying the service pack on a standalone. You
can just run the SP executable. The setup is cluster aware so it'll figure
out the nodes where the files need to be applied.
Linchi
"Knowledgy" wrote:
> go Microsft or the microft developer blogs and you'll find plenty
> --
> Sincerely,
> John K
> Knowledgy Consulting
> http://knowledgy.org/
> Atlanta's Business Intelligence and Data Warehouse Experts
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> > Hey everyone,
> >
> > We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> > install a service pack for SQL 2005.
> >
> > Anyone know of a step-by-step white paper on how to do it in a cluster?
> >
> >
> > TIA,
> >
> >
> > Clayton
> >
>
>
We are running Windows 2003 and SQL 2005 in a cluster. We now need to
install a service pack for SQL 2005.
Anyone know of a step-by-step white paper on how to do it in a cluster?
TIA,
ClaytonIt is documented in this help file.
http://go.microsoft.com/fwlink/?LinkId=71757
Jason Massie
Web: http://statisticsio.com
RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>|||Hey Jason,
Thanks for the reply.
So from reading the below link it sounds like I don't have to stop the
cluster service or anything. Just put the service pack CD in and go for it.
That's not the way it worked when I had to update Exchange 2003 to sp2. I
had to pause each node and stop the cluster service before I could install
the sp.
Clayton
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
> It is documented in this help file.
> http://go.microsoft.com/fwlink/?LinkId=71757
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> Hey everyone,
>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>> install a service pack for SQL 2005.
>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>
>> TIA,
>>
>> Clayton
>|||SQL Service packs are cluster-aware for the clustered components. You run
the SP and it updates the engine components on all nodes. You have to run
it independently on each node to get the tools updated. The tools
installer/updater is not cluster-aware. SSIS is also per-node.
Note that the updater will stop and restart the SQL Server during the update
process. You should consider the SQL Server offline during the upgrade
process.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Clayton Sutton" <none@.none.com> wrote in message
news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
> Hey Jason,
> Thanks for the reply.
> So from reading the below link it sounds like I don't have to stop the
> cluster service or anything. Just put the service pack CD in and go for
> it.
> That's not the way it worked when I had to update Exchange 2003 to sp2. I
> had to pause each node and stop the cluster service before I could install
> the sp.
>
> Clayton
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>> It is documented in this help file.
>> http://go.microsoft.com/fwlink/?LinkId=71757
>>
>> --
>> Jason Massie
>> Web: http://statisticsio.com
>> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> Hey everyone,
>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>> install a service pack for SQL 2005.
>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>
>> TIA,
>>
>> Clayton
>>
>|||Thanks everyone for the info.!
Clayton
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OP89X6gMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> SQL Service packs are cluster-aware for the clustered components. You run
> the SP and it updates the engine components on all nodes. You have to run
> it independently on each node to get the tools updated. The tools
> installer/updater is not cluster-aware. SSIS is also per-node.
> Note that the updater will stop and restart the SQL Server during the
> update process. You should consider the SQL Server offline during the
> upgrade process.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:OUj3j.147664$Eg2.49227@.fe06.news.easynews.com...
>> Hey Jason,
>> Thanks for the reply.
>> So from reading the below link it sounds like I don't have to stop the
>> cluster service or anything. Just put the service pack CD in and go for
>> it.
>> That's not the way it worked when I had to update Exchange 2003 to sp2.
>> I had to pause each node and stop the cluster service before I could
>> install the sp.
>>
>> Clayton
>>
>> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
>> news:OwO3AndMIHA.5860@.TK2MSFTNGP04.phx.gbl...
>> It is documented in this help file.
>> http://go.microsoft.com/fwlink/?LinkId=71757
>>
>> --
>> Jason Massie
>> Web: http://statisticsio.com
>> RSS: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
>> Hey everyone,
>> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
>> install a service pack for SQL 2005.
>> Anyone know of a step-by-step white paper on how to do it in a cluster?
>>
>> TIA,
>>
>> Clayton
>>
>>
>|||go Microsft or the microft developer blogs and you'll find plenty
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Clayton Sutton" <none@.none.com> wrote in message
news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> Hey everyone,
> We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> install a service pack for SQL 2005.
> Anyone know of a step-by-step white paper on how to do it in a cluster?
>
> TIA,
>
> Clayton
>|||Not really that different from applying the service pack on a standalone. You
can just run the SP executable. The setup is cluster aware so it'll figure
out the nodes where the files need to be applied.
Linchi
"Knowledgy" wrote:
> go Microsft or the microft developer blogs and you'll find plenty
> --
> Sincerely,
> John K
> Knowledgy Consulting
> http://knowledgy.org/
> Atlanta's Business Intelligence and Data Warehouse Experts
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:Mfg3j.119679$zb2.66162@.fe02.news.easynews.com...
> > Hey everyone,
> >
> > We are running Windows 2003 and SQL 2005 in a cluster. We now need to
> > install a service pack for SQL 2005.
> >
> > Anyone know of a step-by-step white paper on how to do it in a cluster?
> >
> >
> > TIA,
> >
> >
> > Clayton
> >
>
>
Wednesday, March 7, 2012
How to add a Windows User Login to a database using T-SQL
Hi All,
I'm trying to add a new Windows User to a database using T-SQL. I tried the sp_addlogin system proc, but this doesn't allow backslashes (presumably because it only allows creation of SQL Server logins).
I couldn't find a sproc for this, what's the best way to achieve it?
Thanks,
Simon.
Sorry, being stupid - again!!
sp_grantlogin is all you need...
Friday, February 24, 2012
how to activate product
hi,
I am realy sorry that I am putting this question here since I don't know where to post this question.
We have purchased
Windows server CAL 2003 English OLP NL user CAL
with 5 user license
We got the Microsoft open license agreement after a month or so.
Now I want to know how to proceed with this license.
Since I am newbie to this kindly guide me in this regard.
thanks
Wow, you're really asking in the wrong location - this is a forum for Setup of SQL Server. Still, a quick MSN search provided this link which talks about WS03 product activation:
http://technet2.microsoft.com/WindowsServer/en/Library/db506be2-34f5-4e68-b438-3f3ede902c7a1033.mspx?mfr=true
Good luck!
Paul
Sunday, February 19, 2012
How to access!
Hi everybody,
I want to know how can I access to SQL Server 7.0 (installed on windows 2000) from Other platforms line Win9X in a visual basic program.
Please tell me complete story,
1) What I have to do on server (windows 2000 - MSSQL 7.0)
2) What I have to do on clients (Windows 9X)
3) Connection string to connect to server from client in VB 6.0 language
Thanks :)Ali,
This is a pretty big topic, and you might be better off talking with VB programmers than Database Gurus.
Your VB documentation should tell you how to go about getting data from outside datasources.
My short answer: ODBC connections.
blindman|||Originally posted by blindman
Ali,
This is a pretty big topic, and you might be better off talking with VB programmers than Database Gurus.
Your VB documentation should tell you how to go about getting data from outside datasources.
My short answer: ODBC connections.
blindman
Just a question:
Is there any configuration nedded on Server and Client system?|||Ali,
This is a pretty big topic, and you might be better off talking with VB programmers than Database Gurus.
Your VB documentation should tell you how to go about getting data from outside datasources.
My short answer: ODBC connections.
Unatratnag
1) What I have to do on server (windows 2000 - MSSQL 7.0)
you have to create the database, and if you're doing odbc, then you'll need to create the odbc on the pc where the application resides
2) What I have to do on clients (Windows 9X)
write the code to connect to the database =P
3) Connection string to connect to server from client in VB 6.0 language
well if you have access to the database files create a .udl file and then double click it and it will allow you to create a connection string through the gui, open it back up in notepad and the connection string is the third line.|||People talking about ODBC are running behind for two Microsoft Data Access generations. After ODBC (related to DAO = Data Access Objects) came ADO (= ActiveX Data Objects) with its collection of OLE DB providers, needing as you asked connectionstrings. Currently, we are living in the ADO.NET age, however, you are working with VB 6, which means you would have to choose ADO.
You don't need any extra installations on your server.
On your Win9x client, you need to start with DCOM98. Furthermore, you need MDAC, preferably the latest version 2.7 SP1a. You may browse the www.keper.com (ftp://dbxprof:dbxprof@.FTP server of my DB Explorer for the installations, and you find some hints in the installation manual.
For a discussion of the connection string in trusted environments, or with DB security see ABLE Consulting (http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer). However, you may also want to build a connection string. Herefore, Microsoft utilizes Data Link Property forms, which can be accessed within your application.|||The FTP server link doesn't work. It is DB Explorer (ftp://dbxprof:dbxprof@.213.84.56.3/)|||setup an ADODB connection, use SQLOLEDB as the connection provider.|||I don't think there are Gurus here, just a bunch of people with no life :)
amirnezhad,
The topic may be big, but not the task. What is it you're trying to do? If you want to learn and looking for the way to start, then follow DoktorBlue's links. But if you were given a task to do a specific thing, then post it and someone may give you the whole answer.
P.S.: Since you're from Tehran, how are things looking from there?|||rocheyc: can't figure out the added vaue of your contribution, please help me.
rdjabarov: sounds like you are proposing a new exciting thread about guru properties. Is it really the number of contributions? Or the lack of social life? Or just the nick name? :confused: Maybe the real gurus know ?! ;)|||Originally posted by DoktorBlue
rocheyc: can't figure out the added vaue of your contribution, please help me.
Funny, when I read your post I felt the same way about you!
Originally posted by DoktorBlue
rdjabarov: sounds like you are proposing a new exciting thread about guru properties. Is it really the number of contributions? Or the lack of social life? Or just the nick name? :confused: Maybe the real gurus know ?! ;)
Yes, DoktorBlue the real qurus know.|||Thanks, Paul, you let me see that real gurus don't contribute to the topic, right?
I'd prefer to move further discussions in a new thread, or to keep it private.|||I see the p***ing contest is starting again. Well, I'll be here in the front row watching. Is it time to place bets yet?
I want to know how can I access to SQL Server 7.0 (installed on windows 2000) from Other platforms line Win9X in a visual basic program.
Please tell me complete story,
1) What I have to do on server (windows 2000 - MSSQL 7.0)
2) What I have to do on clients (Windows 9X)
3) Connection string to connect to server from client in VB 6.0 language
Thanks :)Ali,
This is a pretty big topic, and you might be better off talking with VB programmers than Database Gurus.
Your VB documentation should tell you how to go about getting data from outside datasources.
My short answer: ODBC connections.
blindman|||Originally posted by blindman
Ali,
This is a pretty big topic, and you might be better off talking with VB programmers than Database Gurus.
Your VB documentation should tell you how to go about getting data from outside datasources.
My short answer: ODBC connections.
blindman
Just a question:
Is there any configuration nedded on Server and Client system?|||Ali,
This is a pretty big topic, and you might be better off talking with VB programmers than Database Gurus.
Your VB documentation should tell you how to go about getting data from outside datasources.
My short answer: ODBC connections.
Unatratnag
1) What I have to do on server (windows 2000 - MSSQL 7.0)
you have to create the database, and if you're doing odbc, then you'll need to create the odbc on the pc where the application resides
2) What I have to do on clients (Windows 9X)
write the code to connect to the database =P
3) Connection string to connect to server from client in VB 6.0 language
well if you have access to the database files create a .udl file and then double click it and it will allow you to create a connection string through the gui, open it back up in notepad and the connection string is the third line.|||People talking about ODBC are running behind for two Microsoft Data Access generations. After ODBC (related to DAO = Data Access Objects) came ADO (= ActiveX Data Objects) with its collection of OLE DB providers, needing as you asked connectionstrings. Currently, we are living in the ADO.NET age, however, you are working with VB 6, which means you would have to choose ADO.
You don't need any extra installations on your server.
On your Win9x client, you need to start with DCOM98. Furthermore, you need MDAC, preferably the latest version 2.7 SP1a. You may browse the www.keper.com (ftp://dbxprof:dbxprof@.FTP server of my DB Explorer for the installations, and you find some hints in the installation manual.
For a discussion of the connection string in trusted environments, or with DB security see ABLE Consulting (http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer). However, you may also want to build a connection string. Herefore, Microsoft utilizes Data Link Property forms, which can be accessed within your application.|||The FTP server link doesn't work. It is DB Explorer (ftp://dbxprof:dbxprof@.213.84.56.3/)|||setup an ADODB connection, use SQLOLEDB as the connection provider.|||I don't think there are Gurus here, just a bunch of people with no life :)
amirnezhad,
The topic may be big, but not the task. What is it you're trying to do? If you want to learn and looking for the way to start, then follow DoktorBlue's links. But if you were given a task to do a specific thing, then post it and someone may give you the whole answer.
P.S.: Since you're from Tehran, how are things looking from there?|||rocheyc: can't figure out the added vaue of your contribution, please help me.
rdjabarov: sounds like you are proposing a new exciting thread about guru properties. Is it really the number of contributions? Or the lack of social life? Or just the nick name? :confused: Maybe the real gurus know ?! ;)|||Originally posted by DoktorBlue
rocheyc: can't figure out the added vaue of your contribution, please help me.
Funny, when I read your post I felt the same way about you!
Originally posted by DoktorBlue
rdjabarov: sounds like you are proposing a new exciting thread about guru properties. Is it really the number of contributions? Or the lack of social life? Or just the nick name? :confused: Maybe the real gurus know ?! ;)
Yes, DoktorBlue the real qurus know.|||Thanks, Paul, you let me see that real gurus don't contribute to the topic, right?
I'd prefer to move further discussions in a new thread, or to keep it private.|||I see the p***ing contest is starting again. Well, I'll be here in the front row watching. Is it time to place bets yet?
How to access toolbar?
I know the ReportViewer Windows form control has a toolbar. Is there any
way to access it directly? I would like to be able to merge it with my
existing toolbar.
TIA,
Mike RodriguezSorry there is no way to extend the existing toolbar. This is a feature
request for a future version however.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Rodriguez" <mike@.nospam.com> wrote in message
news:uhKrZ42%23FHA.3568@.TK2MSFTNGP09.phx.gbl...
>I know the ReportViewer Windows form control has a toolbar. Is there any
>way to access it directly? I would like to be able to merge it with my
>existing toolbar.
> TIA,
> Mike Rodriguez
>
way to access it directly? I would like to be able to merge it with my
existing toolbar.
TIA,
Mike RodriguezSorry there is no way to extend the existing toolbar. This is a feature
request for a future version however.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Rodriguez" <mike@.nospam.com> wrote in message
news:uhKrZ42%23FHA.3568@.TK2MSFTNGP09.phx.gbl...
>I know the ReportViewer Windows form control has a toolbar. Is there any
>way to access it directly? I would like to be able to merge it with my
>existing toolbar.
> TIA,
> Mike Rodriguez
>
How to access the DB with Integrated Security
Hello,
I'm new to ASP, but developping in Sql for years.
What we would like to have is that the user is accessing the database over it's own Windows Logon. Our triggers log quite some changes and are using UserName() for this. I've treid to force the IIS to accept Windows Integration only, the SqlDataSource users a connection that has Integrated Security = True. But when connection to the site i'm gatting error that there is no trusted connection for the user . (dot) ...
I suppose i'm missing something but could you give me a hint where to start looking.... THX
Hello my friend,
Is the database and the website running on the same domain? I ask because it may be that the SQL Server has no recognition of the Windows account being used on the website server. To cater for future requirements, including the ability of third parties to be able to access this data source, I would use SQL Server authentication (but not the sa account!). Create a sql server user with restrictions on the tables/views/procedures/etc they can use. This is much more secure and extendable than the Windows approach.
Kind regards
Scotty
|||
It is on the same domain.
The mean reason for trying this approach is the triggering, in our classic applications we use the windowslogon and so we can use the username() function in our triggers to log who has changed what values when ... when using a common user we would loose this functionallity, That's why we tried to do this.
A bit stange to me is the proposal of this sql user. And i've seen it in most of the posts i've been reading on these problems, because, the first thing in every book on Sql Security is to close down the SqlServer Logins, and here you have to use them !!
|||Yes and no.
You force the users to connect as SQL logins and then you restrict these logins as much as possible, as opposed to a Windows account. You can configure a sql user to only allow read-only access to 1 column in 1 table out of the whole database if necessary. Disallow everything and then allow as necessary is an approach all of the security books will endorse. I find that the best books on SQL come from Wrox.
Kind regards
Scotty
how to access sql server on windows small businness server 2003
Hello,
I have windows small business server 2003 premium installed, I can see the server service manager but can not start any service(nothing is listed).
How do I set it up?
I can not find the enterprise manager to create a database.
Thanks for your help
The Small Business Server 2003 comes with SQL Server 2000 for 75 users, ISA(internet security server) and Exchange 2003 also for 75 users, how to install the first two is covered below by Microsoft. Hope this helps.
http://download.microsoft.com/download/8/2/4/824e18ac-8503-4277-aeb6-b3f24c316f6c/PremiumInstallSteps.htm
How to access SQL Server on another domain with Windows authentica
I have two computers, client and server. The client is running Windows 2000
Professional and is in a workgroup, say "MyWorkgroup". The server is runnin
g
Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
The server has SQL Server 2000 Standard Edition with SP3a installed and is
using Windows authentication. What I need is to logon to the client as some
generic local administrator user and access SQL Server on the server using
Windows Authentication (i.e. domain user)? How can I do this? Impersonatin
g
a domain user on the server from the client (which is not in the domain, jus
t
in a workgroup)? But how can I do this kind of impersonation? BTW, the
client is written in C++.NET using Windows Forms and accessing SQL Server
using ADO.NET.
Thank you.First try setting the same user and password on both pc and server
login to the pc with the new you name.
Second to your seft to the domain in admin group
I hope this Helps
"CyberDigger" <CyberDigger@.discussions.microsoft.com> wrote in message
news:7DD371D4-22DB-465A-89A3-B3F5DEDEA474@.microsoft.com...
> I have two computers, client and server. The client is running Windows
2000
> Professional and is in a workgroup, say "MyWorkgroup". The server is
running
> Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
> The server has SQL Server 2000 Standard Edition with SP3a installed and is
> using Windows authentication. What I need is to logon to the client as
some
> generic local administrator user and access SQL Server on the server using
> Windows Authentication (i.e. domain user)? How can I do this?
Impersonating
> a domain user on the server from the client (which is not in the domain,
just
> in a workgroup)? But how can I do this kind of impersonation? BTW, the
> client is written in C++.NET using Windows Forms and accessing SQL Server
> using ADO.NET.
> Thank you.|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.security:23830 microso
ft.public.sqlserver.server:376048 microsoft.public.dotnet.security:9420 micr
osoft.public.dotnet.datatools:1593 microsoft.public.sqlserver.programming:49
9446
Your options are:
1) Set the passwords and usernames the same on the local machine in the
workgroup and the domain
2) Use named pipes to connect and Pre-Authenticate (like with a net use
\\server /user:domain\user password) before connecting to sql
3) use sql std logins
Professional and is in a workgroup, say "MyWorkgroup". The server is runnin
g
Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
The server has SQL Server 2000 Standard Edition with SP3a installed and is
using Windows authentication. What I need is to logon to the client as some
generic local administrator user and access SQL Server on the server using
Windows Authentication (i.e. domain user)? How can I do this? Impersonatin
g
a domain user on the server from the client (which is not in the domain, jus
t
in a workgroup)? But how can I do this kind of impersonation? BTW, the
client is written in C++.NET using Windows Forms and accessing SQL Server
using ADO.NET.
Thank you.First try setting the same user and password on both pc and server
login to the pc with the new you name.
Second to your seft to the domain in admin group
I hope this Helps
"CyberDigger" <CyberDigger@.discussions.microsoft.com> wrote in message
news:7DD371D4-22DB-465A-89A3-B3F5DEDEA474@.microsoft.com...
> I have two computers, client and server. The client is running Windows
2000
> Professional and is in a workgroup, say "MyWorkgroup". The server is
running
> Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
> The server has SQL Server 2000 Standard Edition with SP3a installed and is
> using Windows authentication. What I need is to logon to the client as
some
> generic local administrator user and access SQL Server on the server using
> Windows Authentication (i.e. domain user)? How can I do this?
Impersonating
> a domain user on the server from the client (which is not in the domain,
just
> in a workgroup)? But how can I do this kind of impersonation? BTW, the
> client is written in C++.NET using Windows Forms and accessing SQL Server
> using ADO.NET.
> Thank you.|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.security:23830 microso
ft.public.sqlserver.server:376048 microsoft.public.dotnet.security:9420 micr
osoft.public.dotnet.datatools:1593 microsoft.public.sqlserver.programming:49
9446
Your options are:
1) Set the passwords and usernames the same on the local machine in the
workgroup and the domain
2) Use named pipes to connect and Pre-Authenticate (like with a net use
\\server /user:domain\user password) before connecting to sql
3) use sql std logins
How to access SQL Server on another domain with Windows authentica
I have two computers, client and server. The client is running Windows 2000
Professional and is in a workgroup, say "MyWorkgroup". The server is running
Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
The server has SQL Server 2000 Standard Edition with SP3a installed and is
using Windows authentication. What I need is to logon to the client as some
generic local administrator user and access SQL Server on the server using
Windows Authentication (i.e. domain user)? How can I do this? Impersonating
a domain user on the server from the client (which is not in the domain, just
in a workgroup)? But how can I do this kind of impersonation? BTW, the
client is written in C++.NET using Windows Forms and accessing SQL Server
using ADO.NET.
Thank you.
CyberDigger,
so let me understand your problem clearly first.
One is a server running Sql Server (Win 2k3) This is in MyDoman.
Second is a client running your winforms app. (Win2k) This is in
MyWorkGroup.
You want -- to connect to the sql server database, using the credentials
used to log on to the local client box?
I don't think that's do-able since the anything on the domain will never be
able to validate locally entered credentials on the client. The best you can
do is to remote over to the win2k3 server itself and something running on
the win2k3 server with sufficient privelleges in the domain acts as your
data layer - that might be an acceptable solution?
I hope I'm wrong though
- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
"CyberDigger" <CyberDigger@.discussions.microsoft.com> wrote in message
news:3B3A9B3F-B2F5-4924-B0A5-B53D41A10FD1@.microsoft.com...
>I have two computers, client and server. The client is running Windows
>2000
> Professional and is in a workgroup, say "MyWorkgroup". The server is
> running
> Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
> The server has SQL Server 2000 Standard Edition with SP3a installed and is
> using Windows authentication. What I need is to logon to the client as
> some
> generic local administrator user and access SQL Server on the server using
> Windows Authentication (i.e. domain user)? How can I do this?
> Impersonating
> a domain user on the server from the client (which is not in the domain,
> just
> in a workgroup)? But how can I do this kind of impersonation? BTW, the
> client is written in C++.NET using Windows Forms and accessing SQL Server
> using ADO.NET.
> Thank you.
|||Perhaps you can setup a linked server (which includes the remote
credentials) and use that in the server-side join...
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Sahil Malik" <contactmethrumyblog@.nospam.com> wrote in message
news:%23ZkzzIh9EHA.2676@.TK2MSFTNGP12.phx.gbl...
> CyberDigger,
> so let me understand your problem clearly first.
> One is a server running Sql Server (Win 2k3) This is in MyDoman.
> Second is a client running your winforms app. (Win2k) This is in
> MyWorkGroup.
> You want -- to connect to the sql server database, using the credentials
> used to log on to the local client box?
> I don't think that's do-able since the anything on the domain will never
> be able to validate locally entered credentials on the client. The best
> you can do is to remote over to the win2k3 server itself and something
> running on the win2k3 server with sufficient privelleges in the domain
> acts as your data layer - that might be an acceptable solution?
> I hope I'm wrong though
> - Sahil Malik
> http://dotnetjunkies.com/weblog/sahilmalik
>
>
> "CyberDigger" <CyberDigger@.discussions.microsoft.com> wrote in message
> news:3B3A9B3F-B2F5-4924-B0A5-B53D41A10FD1@.microsoft.com...
>
|||Yeah that's a good idea.
- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:exowOHr9EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Perhaps you can setup a linked server (which includes the remote
> credentials) and use that in the server-side join...
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> "Sahil Malik" <contactmethrumyblog@.nospam.com> wrote in message
> news:%23ZkzzIh9EHA.2676@.TK2MSFTNGP12.phx.gbl...
>
|||Here is a way you can do it:
On the server, set up a local NT/2000 account with the same login name and
password as used to log into the workstation.
Give that account permission using NT Authentication.
Use NT Authentication on clients from the workstation.
I will caution you that when you do this, if you change your password at the
local workstation, you will get logon errors unless you synchronize your
password on the server.
"CyberDigger" wrote:
> I have two computers, client and server. The client is running Windows 2000
> Professional and is in a workgroup, say "MyWorkgroup". The server is running
> Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
> The server has SQL Server 2000 Standard Edition with SP3a installed and is
> using Windows authentication. What I need is to logon to the client as some
> generic local administrator user and access SQL Server on the server using
> Windows Authentication (i.e. domain user)? How can I do this? Impersonating
> a domain user on the server from the client (which is not in the domain, just
> in a workgroup)? But how can I do this kind of impersonation? BTW, the
> client is written in C++.NET using Windows Forms and accessing SQL Server
> using ADO.NET.
> Thank you.
Professional and is in a workgroup, say "MyWorkgroup". The server is running
Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
The server has SQL Server 2000 Standard Edition with SP3a installed and is
using Windows authentication. What I need is to logon to the client as some
generic local administrator user and access SQL Server on the server using
Windows Authentication (i.e. domain user)? How can I do this? Impersonating
a domain user on the server from the client (which is not in the domain, just
in a workgroup)? But how can I do this kind of impersonation? BTW, the
client is written in C++.NET using Windows Forms and accessing SQL Server
using ADO.NET.
Thank you.
CyberDigger,
so let me understand your problem clearly first.
One is a server running Sql Server (Win 2k3) This is in MyDoman.
Second is a client running your winforms app. (Win2k) This is in
MyWorkGroup.
You want -- to connect to the sql server database, using the credentials
used to log on to the local client box?
I don't think that's do-able since the anything on the domain will never be
able to validate locally entered credentials on the client. The best you can
do is to remote over to the win2k3 server itself and something running on
the win2k3 server with sufficient privelleges in the domain acts as your
data layer - that might be an acceptable solution?
I hope I'm wrong though
- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
"CyberDigger" <CyberDigger@.discussions.microsoft.com> wrote in message
news:3B3A9B3F-B2F5-4924-B0A5-B53D41A10FD1@.microsoft.com...
>I have two computers, client and server. The client is running Windows
>2000
> Professional and is in a workgroup, say "MyWorkgroup". The server is
> running
> Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
> The server has SQL Server 2000 Standard Edition with SP3a installed and is
> using Windows authentication. What I need is to logon to the client as
> some
> generic local administrator user and access SQL Server on the server using
> Windows Authentication (i.e. domain user)? How can I do this?
> Impersonating
> a domain user on the server from the client (which is not in the domain,
> just
> in a workgroup)? But how can I do this kind of impersonation? BTW, the
> client is written in C++.NET using Windows Forms and accessing SQL Server
> using ADO.NET.
> Thank you.
|||Perhaps you can setup a linked server (which includes the remote
credentials) and use that in the server-side join...
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Sahil Malik" <contactmethrumyblog@.nospam.com> wrote in message
news:%23ZkzzIh9EHA.2676@.TK2MSFTNGP12.phx.gbl...
> CyberDigger,
> so let me understand your problem clearly first.
> One is a server running Sql Server (Win 2k3) This is in MyDoman.
> Second is a client running your winforms app. (Win2k) This is in
> MyWorkGroup.
> You want -- to connect to the sql server database, using the credentials
> used to log on to the local client box?
> I don't think that's do-able since the anything on the domain will never
> be able to validate locally entered credentials on the client. The best
> you can do is to remote over to the win2k3 server itself and something
> running on the win2k3 server with sufficient privelleges in the domain
> acts as your data layer - that might be an acceptable solution?
> I hope I'm wrong though
> - Sahil Malik
> http://dotnetjunkies.com/weblog/sahilmalik
>
>
> "CyberDigger" <CyberDigger@.discussions.microsoft.com> wrote in message
> news:3B3A9B3F-B2F5-4924-B0A5-B53D41A10FD1@.microsoft.com...
>
|||Yeah that's a good idea.
- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:exowOHr9EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Perhaps you can setup a linked server (which includes the remote
> credentials) and use that in the server-side join...
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> "Sahil Malik" <contactmethrumyblog@.nospam.com> wrote in message
> news:%23ZkzzIh9EHA.2676@.TK2MSFTNGP12.phx.gbl...
>
|||Here is a way you can do it:
On the server, set up a local NT/2000 account with the same login name and
password as used to log into the workstation.
Give that account permission using NT Authentication.
Use NT Authentication on clients from the workstation.
I will caution you that when you do this, if you change your password at the
local workstation, you will get logon errors unless you synchronize your
password on the server.
"CyberDigger" wrote:
> I have two computers, client and server. The client is running Windows 2000
> Professional and is in a workgroup, say "MyWorkgroup". The server is running
> Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
> The server has SQL Server 2000 Standard Edition with SP3a installed and is
> using Windows authentication. What I need is to logon to the client as some
> generic local administrator user and access SQL Server on the server using
> Windows Authentication (i.e. domain user)? How can I do this? Impersonating
> a domain user on the server from the client (which is not in the domain, just
> in a workgroup)? But how can I do this kind of impersonation? BTW, the
> client is written in C++.NET using Windows Forms and accessing SQL Server
> using ADO.NET.
> Thank you.
How to access SQL Server on another domain with Windows authentica
I have two computers, client and server. The client is running Windows 2000
Professional and is in a workgroup, say "MyWorkgroup". The server is running
Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
The server has SQL Server 2000 Standard Edition with SP3a installed and is
using Windows authentication. What I need is to logon to the client as some
generic local administrator user and access SQL Server on the server using
Windows Authentication (i.e. domain user)? How can I do this? Impersonating
a domain user on the server from the client (which is not in the domain, just
in a workgroup)? But how can I do this kind of impersonation? BTW, the
client is written in C++.NET using Windows Forms and accessing SQL Server
using ADO.NET.
Thank you.
First try setting the same user and password on both pc and server
login to the pc with the new you name.
Second to your seft to the domain in admin group
I hope this Helps
"CyberDigger" <CyberDigger@.discussions.microsoft.com> wrote in message
news:7DD371D4-22DB-465A-89A3-B3F5DEDEA474@.microsoft.com...
> I have two computers, client and server. The client is running Windows
2000
> Professional and is in a workgroup, say "MyWorkgroup". The server is
running
> Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
> The server has SQL Server 2000 Standard Edition with SP3a installed and is
> using Windows authentication. What I need is to logon to the client as
some
> generic local administrator user and access SQL Server on the server using
> Windows Authentication (i.e. domain user)? How can I do this?
Impersonating
> a domain user on the server from the client (which is not in the domain,
just
> in a workgroup)? But how can I do this kind of impersonation? BTW, the
> client is written in C++.NET using Windows Forms and accessing SQL Server
> using ADO.NET.
> Thank you.
|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.security:23830 microsoft.public.sqlserver.server:376048 microsoft.public.dotnet.security:9420 microsoft.public.dotnet.datatools:1593 microsoft.public.sqlserver.programming:499446
Your options are:
1) Set the passwords and usernames the same on the local machine in the
workgroup and the domain
2) Use named pipes to connect and Pre-Authenticate (like with a net use
\\server /user:domain\user password) before connecting to sql
3) use sql std logins
Professional and is in a workgroup, say "MyWorkgroup". The server is running
Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
The server has SQL Server 2000 Standard Edition with SP3a installed and is
using Windows authentication. What I need is to logon to the client as some
generic local administrator user and access SQL Server on the server using
Windows Authentication (i.e. domain user)? How can I do this? Impersonating
a domain user on the server from the client (which is not in the domain, just
in a workgroup)? But how can I do this kind of impersonation? BTW, the
client is written in C++.NET using Windows Forms and accessing SQL Server
using ADO.NET.
Thank you.
First try setting the same user and password on both pc and server
login to the pc with the new you name.
Second to your seft to the domain in admin group
I hope this Helps
"CyberDigger" <CyberDigger@.discussions.microsoft.com> wrote in message
news:7DD371D4-22DB-465A-89A3-B3F5DEDEA474@.microsoft.com...
> I have two computers, client and server. The client is running Windows
2000
> Professional and is in a workgroup, say "MyWorkgroup". The server is
running
> Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
> The server has SQL Server 2000 Standard Edition with SP3a installed and is
> using Windows authentication. What I need is to logon to the client as
some
> generic local administrator user and access SQL Server on the server using
> Windows Authentication (i.e. domain user)? How can I do this?
Impersonating
> a domain user on the server from the client (which is not in the domain,
just
> in a workgroup)? But how can I do this kind of impersonation? BTW, the
> client is written in C++.NET using Windows Forms and accessing SQL Server
> using ADO.NET.
> Thank you.
|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.security:23830 microsoft.public.sqlserver.server:376048 microsoft.public.dotnet.security:9420 microsoft.public.dotnet.datatools:1593 microsoft.public.sqlserver.programming:499446
Your options are:
1) Set the passwords and usernames the same on the local machine in the
workgroup and the domain
2) Use named pipes to connect and Pre-Authenticate (like with a net use
\\server /user:domain\user password) before connecting to sql
3) use sql std logins
Subscribe to:
Posts (Atom)