SQLAgentMail: windows

Showing posts with label windows. Show all posts

Friday, March 23, 2012

Question on upgrade to SQL Server 2005

We are planning to upgrade one of the SQL Server 2000 instance on a
windows 2003 box to SQL Server 2005. I was wondering during the upgrade
will it allow me to chang the name of the existing 2000 instance to a
different name so that we can follow our naming convention.
ThanksSQL Server takes the name of the machine. So, you will have to rename the
machine, and then edit the local server name in the sysservers table.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"shub" <shubtech@.gmail.com> wrote in message
news:1153428116.503813.172530@.p79g2000cwp.googlegroups.com...
> We are planning to upgrade one of the SQL Server 2000 instance on a
> windows 2003 box to SQL Server 2005. I was wondering during the upgrade
> will it allow me to chang the name of the existing 2000 instance to a
> different name so that we can follow our naming convention.
> Thanks
>|||Yes you can rename an Instance -before the upgrade. See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
I think that renaming instances is not currently supported in SQL 2005
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"shub" <shubtech@.gmail.com> wrote in message
news:1153428116.503813.172530@.p79g2000cwp.googlegroups.com...
> We are planning to upgrade one of the SQL Server 2000 instance on a
> windows 2003 box to SQL Server 2005. I was wondering during the upgrade
> will it allow me to chang the name of the existing 2000 instance to a
> different name so that we can follow our naming convention.
> Thanks
>

Wednesday, March 21, 2012

Question on SQL Server 2000 installation

I am trying to install on SQL Server 2000 on Windows server 2003, web
edition. When I click on autorun, then choose server tools and components and
choose Install Server, nothing happens.
I was wondering if it possible to install SQL Server 2000 on Windows Server
2003 web edition. Is this a compatibility issue'
Thank you.
VamsheeWindows Server 2003 Web Server Edition will not allow you to install SQL
Server 2000. It is not a licensed configuration.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Vamshee" <Vamshee@.discussions.microsoft.com> wrote in message
news:56A57D60-720F-4512-AA27-53045E73DD7C@.microsoft.com...
> I am trying to install on SQL Server 2000 on Windows server 2003, web
> edition. When I click on autorun, then choose server tools and components
and
> choose Install Server, nothing happens.
> I was wondering if it possible to install SQL Server 2000 on Windows
Server
> 2003 web edition. Is this a compatibility issue'
> Thank you.
> Vamshee|||Hi,
Organizations cannot use Windows Server 2003, Web Edition, to deploy
Microsoft SQL Server.
See the below link (Limitations paragraph):-
http://www.microsoft.com/windowsserver2003/evaluation/overview/web.mspx
Thanks
Hari
SQL Server MVP
"Geoff N. Hiten" wrote:
> Windows Server 2003 Web Server Edition will not allow you to install SQL
> Server 2000. It is not a licensed configuration.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Vamshee" <Vamshee@.discussions.microsoft.com> wrote in message
> news:56A57D60-720F-4512-AA27-53045E73DD7C@.microsoft.com...
> > I am trying to install on SQL Server 2000 on Windows server 2003, web
> > edition. When I click on autorun, then choose server tools and components
> and
> > choose Install Server, nothing happens.
> >
> > I was wondering if it possible to install SQL Server 2000 on Windows
> Server
> > 2003 web edition. Is this a compatibility issue'
> >
> > Thank you.
> > Vamshee
>
>|||Thanks for the information.
"Hari Prasad" wrote:
> Hi,
> Organizations cannot use Windows Server 2003, Web Edition, to deploy
> Microsoft SQL Server.
> See the below link (Limitations paragraph):-
> http://www.microsoft.com/windowsserver2003/evaluation/overview/web.mspx
> Thanks
> Hari
> SQL Server MVP
>
> "Geoff N. Hiten" wrote:
> > Windows Server 2003 Web Server Edition will not allow you to install SQL
> > Server 2000. It is not a licensed configuration.
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "Vamshee" <Vamshee@.discussions.microsoft.com> wrote in message
> > news:56A57D60-720F-4512-AA27-53045E73DD7C@.microsoft.com...
> > > I am trying to install on SQL Server 2000 on Windows server 2003, web
> > > edition. When I click on autorun, then choose server tools and components
> > and
> > > choose Install Server, nothing happens.
> > >
> > > I was wondering if it possible to install SQL Server 2000 on Windows
> > Server
> > > 2003 web edition. Is this a compatibility issue'
> > >
> > > Thank you.
> > > Vamshee
> >
> >
> >sql

Friday, March 9, 2012

Question on installing the SQL Server 2005 Developer Edition on the Windows Vista

I cannot find any specific info on the support of SQL server 2005 developer edition on different Windows Vista. Does anyone have any experience? TIAjust refer, http://msdn2.microsoft.com/en-us/library/ms143506.aspx|||My experience is very problematical. I've tried installing it several times on my new Vista 64 Ultimate machine, and each time I wind up with only the Express edition, not the full/Enterprise edition as I was able to do on my prior XP Professional machine. Being limited to Express is a problem, since the test database I have from my client exceeds the 4GB threshold that the Express Edition imposes. If anyone has had better luck, or knows hoow to do this better, I'd love to hear about it.

Wednesday, March 7, 2012

Question on getting the date value into a filename

I am running the following sqllitespeed backup script on Windows 2003 Server
against SQL Server 2000

sqllitespeed -Bdatabase -T -DNorthwind -FH:\MicrosoftSQLServer\BACKUPS\DATABACKUPS\NorthWi nd\northwind.bak

How could I place the date variable into the output filename?

I've tried variations of %date% etc but nada.

Any thoughts?

Thanks in advance.

Gerryhow do you executye this? Command line?, xp_cmdshell?|||It would be in a script run by an external controller.
A batch file.|||OK, batch file

I would use T-SQL to create said batch fiile, and as a matter of fact I would have a sql server job lauch said batch file

Saturday, February 25, 2012

Question on connection to SQL Server using windows authentication

I have a domain user account through which I can log on a machine. The machine allows me to use this domain user account to create DB in SQL Server using windows authentication. How can I define a connection string to connect SQL Server? My connection string is like:
string str = "server=(local);uid='"+userName+"';password='"+password+"';database='master';connection timeout=15";

This one works on another machine where I use SA account. But this one does not work using windows authentication. I tried to use domainname\myname as user name, but failed.
Could any one give me some suggestion?I solved the problem.|||Hi bagofbones.

I have the same problem.

Please post your solution.

Thanks.

Friday, March 23, 2012

Question on upgrade to SQL Server 2005

Wednesday, March 21, 2012

Question on SQL Server 2000 installation

Question on SQL Server 2000 installation

Question on SQL Server 2000 installation

Friday, March 9, 2012

Question on installing the SQL Server 2005 Developer Edition on the Windows Vista

Wednesday, March 7, 2012

Question on getting the date value into a filename

Saturday, February 25, 2012

Question on connection to SQL Server using windows authentication

SQLAgentMail

Blog Archive

About Me