Instance name contains a dash

Hello

We are in the process of upgrading our SQL 2K server to a cluster environment. Currently the server is setup as a default instance running on a single box with log shipping as a warm backup

It is required to create an instance name for the new cluster to work. My question is

1) Has anybody tried to have an instance name that dash (-) in it.

Example: \\SERVERNAME\xxx-xx-xxx

I am told that it is not possible to have a server instance named this way. Would like to know if this naming convention is possible under SQL2K If not what is the suggested workaround

This will save a lot of time in application modifications

Thanks in advance

Gabe J

Don't do it, invest the work now and you will have a much more relaxing future. If it takes much time to modify your application to work with another instance name you probably have a design issue in your application.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for the advice.

SQL 2000 books online does not specifically mention that dash (-) cannot be used in an instance name ( you can even create tables and other objects in a database that contains a dash in them why not instance name?). Could you please be a little more specific as what exactly the issues would be if the instance name contained dashes.

I have to justify the requirement to make program changes, for that I need to understand what the issues are going to be.

Appreciate your help

Gabe J

|||

I don′t have any specific issue in mind that I can tell of if you use special characters in instance names. Sure you can have special characters in Tables and other objects, but "What you can do" is often the opposite "What is prefered to do". As from my experience I wouldn′t bet on that horse and take the risk of naming the object or even the instance with special characters, although I can. Thats just my two cents, perhaps someone has another opinion about that, but unless you have a hand on your code and have the opportunity to correct that thing (as of my opinion) I would that effort in it.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

In general I agree with what Jens has to say. As far as I know, putting a dash in the instance name is supported. I remember back in the 7.0 days testers went to a lot of trouble to make sure that dashes worked fine in the server name. I don't remember finding any issues there (but it was a long time ago). I do seem to remember that our automation at the time needed multiple changes to run on those servers. :(

The effort was worth it for Microsoft but might not be for your arbitrary application.

|||

One of the suggestions made to get around with this issue is to place a registry hack by adding a key called "Connectto" in the following node

HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSSQLServer\Client\

And specify the value as the OLD server name = "XXX-XX-XXX"

and data = DBNMPNTW,\\<New Server name>\pipe\MSSQL$<Instance name>\sql\query

When applications connect irrespective of the connection string, this registry value connects to the SQL server instance.

Seems to work . Agree this is just a workaround instead of solving the real issue of making application modifications.

Has anyone tried this ?

Thanks for you suggestions

|||

Not sure where you heard about this registry hack, but I would not recommend using it unless it was mentioned in a specific Microsoft article...This ***hack*** may not work after a future release. Looks like this workaround maybe setting up a alias for the server. If this is the case, you should use SQL Server Configuration Manager instead.

As others have said, I am not really sure if dashes are supported, but I would not use...SQL Server maybe able to handle it fine, but some other external component may not.

Thanks,

Peter Saddow

|||

Agree that this is a **hack**. The SQL Server is a 2K version not 2005. How do I use the configuration manager to set up and alias name for the instance at the server level?

Thanks

|||

For SQL Server 2000, use SQL Server Client Network Utility. Select the "Alias" tab and enter the required information.

Hope this helps,

Peter Saddow

Installing SSRS 2005 in web server and cluster environment.

Hi,

I am installing SSRS 2005 with the following scenario:

- Report Server and Report Manager will be installed on web server

- The repository databases (ReportServer and ReportServerTempDB) will be hosted in SQL2005 cluster server.

Both servers are running Win2003 SP1, SQL/SSRS 2005 SP1

When I try to browse the ReportServer virtual directory from IIS on the web server, the system keep asking username and password. After 3 times trials and it failed eventhough the username and password is correct.

The error message is:

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)

I've been searching on the web and found couple of articles talking about this issue. I've tried some of them like: http://support.microsoft.com/kb/887993 or even this one: http://groups.google.ca/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/991c9178ceab8f58/8f1a447aa60ad837?lnk=st&q=reporting+services+the+server+is+not+responding&rnum=3&hl=en#8f1a447aa60ad837

But this doesn't work.

I've checked both event viewer both web server and SQL server, but I can't see any information that tell me what had happened.

I also look at BOL, but doesn't help much.

Is there anyone can help me or point me to the right direction? Is there any guide document that explains step-by-step how to install SSRS in my scenario or similiar?

Many Thanks,

Usman Tjiudri

I have the exact same issue in a identical envirnonment configuration. Did you get this resolved?

I`m looking at a few articles re Kerberos....

|||Hi,

Yes, finally I got this issue resolved.
After looking for answer almost everywhere, I finally turn to Microsoft Support and they gave me a very quick response (less than 24 hours).
Before I talk about the solution, I need to clarify something here - my environment is Win2003 Server R2 (not Win2003 SP1 as mentioned in previous email) - may be there's a SP1 for R2.
The issue is caused by IIS. Apparently R2 has different version of IIS with normal Win2003 Server.
You need to uninstall completely IIS on your server (may be you need to backup IIS metadata) and install IIS for R2. You can get the software from R2 disc.
If you still can't solve the issue, log it to Microsoft Support.

Let me know how it goes.

Hope This Help,
Usman Tjiudri

Installing SSRS 2005 in web server and cluster environment.

Hi,

I am installing SSRS 2005 with the following scenario:

- Report Server and Report Manager will be installed on web server

- The repository databases (ReportServer and ReportServerTempDB) will be hosted in SQL2005 cluster server.

Both servers are running Win2003 SP1, SQL/SSRS 2005 SP1

When I try to browse the ReportServer virtual directory from IIS on the web server, the system keep asking username and password. After 3 times trials and it failed eventhough the username and password is correct.

The error message is:

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)

I've been searching on the web and found couple of articles talking about this issue. I've tried some of them like: http://support.microsoft.com/kb/887993 or even this one: http://groups.google.ca/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/991c9178ceab8f58/8f1a447aa60ad837?lnk=st&q=reporting+services+the+server+is+not+responding&rnum=3&hl=en#8f1a447aa60ad837

But this doesn't work.

I've checked both event viewer both web server and SQL server, but I can't see any information that tell me what had happened.

I also look at BOL, but doesn't help much.

Is there anyone can help me or point me to the right direction? Is there any guide document that explains step-by-step how to install SSRS in my scenario or similiar?

Many Thanks,

Usman Tjiudri

I have the exact same issue in a identical envirnonment configuration. Did you get this resolved?

I`m looking at a few articles re Kerberos....

|||Hi,

Yes, finally I got this issue resolved.
After looking for answer almost everywhere, I finally turn to Microsoft Support and they gave me a very quick response (less than 24 hours).
Before I talk about the solution, I need to clarify something here - my environment is Win2003 Server R2 (not Win2003 SP1 as mentioned in previous email) - may be there's a SP1 for R2.
The issue is caused by IIS. Apparently R2 has different version of IIS with normal Win2003 Server.
You need to uninstall completely IIS on your server (may be you need to backup IIS metadata) and install IIS for R2. You can get the software from R2 disc.
If you still can't solve the issue, log it to Microsoft Support.

Let me know how it goes.

Hope This Help,
Usman Tjiudri

sql

Installing SQL Server 2005 Developer

Hello,

When installing SQL Server 2005 developer, I get the error:

Product : Visual Studio Integrated Development Environment 2005
Error : Internal Error 2356. _14248_Microsoft_VC80_MFC_x86.msm

Any idea why this is happening?

Thanks.

Hi,

For SQL specific setup question, please see or post your question in the below URL:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1

Thanks,

Lan

integrated development environment for Reporting Services

Is there a development environment for Reporting Services (2005) that is integrated with source control?

You can use Visual Studio to develop reports and place them under source control. But as far as I can tell, you cannot implement security, scheduling, etc. through Visual Studio. For these you can use a second environment, e.g. SQL Server Management Studio - but is this environment integrated with TFS?

In other words, is there a single development environment, integrated with TFS, where you can develop all aspects of Reporting Services reports?

I wouldn't get all excited about using SQL Server Management Studio for that second set of tasks, since they have pretty much indicated that they would prefer to concentrate on making Report Manager and Sharepoint the tools for this purpose in Katmai. I think the Management Studio snap-in approach didn't give them the flexibility they wanted, it's kind of rigid.

Please read below, from Brian Welcker's Weblog (http://blogs.msdn.com/bwelcker/ ) --

Meanwhile, remember that all the details you are actually configuring through either approach are actually in a database... So you do have ways of versioning them by taking snapshots of data.

I don't mean to make light of your concerns, and source control isn't directly integrated with the report management data that's in the database. As far as I know, it's aimed at scripting work (you can read this http://msdn2.microsoft.com/en-us/library/ms173550.aspx for information) .

But the data itself can be backed up on a regular, versioned basis and you can probably check the whole .BAK file into your source control repository if you want to (I don't know what you'd gain, but ReportServer DB's are metadata, they aren't going to be huge). If you created scripts for this purpose, you would of course have the integrated ability to version the scripts.

HTH -- see below for the Katmai information I was referring to...

>L<

(snip) - (http://blogs.msdn.com/bwelcker/ )

Watusi (SSRS Management Tools Changes for Katmai)

For Katmai we are considering the removal of namespace management (folders,
reports, data sources, models) from the Reporting Services Add-in for SQL
Server Management Studio (SSMS). In other words, we are considering removing
the 'Home' folder under the Reporting Server node in SSMS.

Why the change?

Customer feedback and usage data indicates that Report Manager and/or
SharePoint are the tools of choice for managing the Report Server namespace,
rather than the SSMS add-in. The design constraints of SSMS mean that any
new namespace functionality is significantly expensive to implement,
specifically adding support for the namespace in SharePoint integrated mode.
For Katmai we want to invest in SharePoint and Report Manager for namespace
management and focus on SSMS as a server-level management tool.

This means that the namespace management functions that are not available in
Report Manager (Model ClickThrough and Model Item Security) will be added to
Report Manager (they are already in SharePoint). Job Management, configuring
System properties, and administering Roles will be moved to SSMS. In
addition, SSMS will be updated to work in SharePoint mode.

If you have feedback about these changes, please feel free to comment.

Integrate PowerPoint and Reporting Services?

I am trying to move many of our group's monthly report functions from
Excel workbooks to a common Reporting Services environment, so data
will be visible to everyone at the end of the reporting period.
However, some of these slides have found their way into committee
meetings, which are driven entirely out of PowerPoint presentations.
I am being hit with a request to merge RS Reports with the existing
PowerPoint presentations. Unfortunately, while RS does render to the
screen, there is no easy way to copy the output to a file at a quality
level equivalent to what we had.
Right now, I can save my reports to Excel, then copy-paste the Range
into PowerPoint, but many times the built-in export fails to render
like the Report shows the data on the screen, often including cell
borders in Excel that were not specified in the HTML as well as other
spacing weirdness.
* Is there way I can include an embedded object in PowerPoint that
references a ReportViewer that pulls from the Reporting Server? The
Include Object menu in PP does not list this as an option.
* Is there a way to build a custom Render function to output the whole
page to a WMF (Windows MetaFile) format?
-- ScottOn Nov 9, 4:44 pm, Orne <polysilly...@.yahoo.com> wrote:
> I am trying to move many of our group's monthly report functions from
> Excel workbooks to a common Reporting Services environment, so data
> will be visible to everyone at the end of the reporting period.
> However, some of these slides have found their way into committee
> meetings, which are driven entirely out of PowerPoint presentations.
> I am being hit with a request to merge RS Reports with the existing
> PowerPoint presentations. Unfortunately, while RS does render to the
> screen, there is no easy way to copy the output to a file at a quality
> level equivalent to what we had.
> Right now, I can save my reports to Excel, then copy-paste the Range
> into PowerPoint, but many times the built-in export fails to render
> like the Report shows the data on the screen, often including cell
> borders in Excel that were not specified in the HTML as well as other
> spacing weirdness.
> * Is there way I can include an embedded object in PowerPoint that
> references a ReportViewer that pulls from the Reporting Server? The
> Include Object menu in PP does not list this as an option.
> * Is there a way to build a custom Render function to output the whole
> page to a WMF (Windows MetaFile) format?
> -- Scott
I can't speak directly to your scenario; however, you could either try
creating a custom renderer to render in Power Point from SSRS/
Reporting Services (http://msdn.microsoft.com/msdnmag/issues/05/02/
CustomRenderers/default.aspx ) -or- you could purchase a third party
tool (http://www.downloadjunction.com/product/software/135002/
index.html ). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Nov 9, 7:01 pm, EMartinez <emartinez...@.gmail.com> wrote:
> I can't speak directly to your scenario; however, you could either try
> creating a custom renderer to render in Power Point from SSRS/
> Reporting Services (http://msdn.microsoft.com/msdnmag/issues/05/02/
> CustomRenderers/default.aspx ) -or- you could purchase a third party
> tool (http://www.downloadjunction.com/product/software/135002/
> index.html ). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks, this is very promising!
-- Scott|||On Nov 12, 8:01 am, Orne <polysilly...@.yahoo.com> wrote:
> On Nov 9, 7:01 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > I can't speak directly to your scenario; however, you could either try
> > creating a custom renderer to render in Power Point from SSRS/
> > Reporting Services (http://msdn.microsoft.com/msdnmag/issues/05/02/
> > CustomRenderers/default.aspx ) -or- you could purchase a third party
> > tool (http://www.downloadjunction.com/product/software/135002/
> > index.html ). Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks, this is very promising!
> -- Scott
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Installing SQL Server 2000 SP3a

I got this message from

Backup Exec for Windows Servers Environment Check 1.0 for SBS1

QUOTE

An instance of Microsoft SQL 2000 was found that is not updated to Service Pack 3a.

An instance of Microsoft SQL Server was found that is not updated to the correct service pack. Using this SQL Server instance with Backup Exec may cause errors. To install Backup Exec successfully, upgrade this SQL Server to Service Pack 3a, or select another instance.

Instance: SBSMONITORING, Version: 2000 SP 3a
Instance: SHAREPOINT, Version: 2000 SP 3a
Instance: BKUPEXEC, Version: 2000 SP 3a
Instance: PADMINISTRATOR, Version: 2000 SP 3a
Instance: MICROSOFT##SSEE, Version: 2000

UNQUOTE

My Question is how to upgrade the instance : "MICROSOFT##SSEE, Version: 2000" to SP 3a?

Its better to apply sp4 to the server, since Mainstream Support for sql 2000 is going retire at 4/8/2008.

Kindly specify your OS with service pack installed to analyze further|||

You can download SQL 2000 SP4 from here:

http://www.microsoft.com/downloads/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en

Thanks,
Sam Lester (MSFT)|||

Thank you Vidhya. I apply Sp4

regards Theo

|||

Sam thank you. I already downloaded the files.

Regards Theo

|||

Hi, I wonder if anyone can help me.

I have the same issue. When attempting to install SP4 using the command:

setup /upgradesp sqlrun INSTANCENAME=MICROSOFT##SSEE /L*v d:\msdelog.log

I get the error:

"The product is not installed. Check it a appropriate instance of MSDE is installed."

Can anyone shed any light on this?

Thanks

Installing SQL Server 2000 SP3a

I got this message from

Backup Exec for Windows Servers Environment Check 1.0 for SBS1

QUOTE

An instance of Microsoft SQL 2000 was found that is not updated to Service Pack 3a.

An instance of Microsoft SQL Server was found that is not updated to the correct service pack. Using this SQL Server instance with Backup Exec may cause errors. To install Backup Exec successfully, upgrade this SQL Server to Service Pack 3a, or select another instance.

Instance: SBSMONITORING, Version: 2000 SP 3a
Instance: SHAREPOINT, Version: 2000 SP 3a
Instance: BKUPEXEC, Version: 2000 SP 3a
Instance: PADMINISTRATOR, Version: 2000 SP 3a
Instance: MICROSOFT##SSEE, Version: 2000

UNQUOTE

My Question is how to upgrade the instance : "MICROSOFT##SSEE, Version: 2000" to SP 3a?

Its better to apply sp4 to the server, since Mainstream Support for sql 2000 is going retire at 4/8/2008.

Kindly specify your OS with service pack installed to analyze further|||

You can download SQL 2000 SP4 from here:

http://www.microsoft.com/downloads/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en

Thanks,
Sam Lester (MSFT)|||

Thank you Vidhya. I apply Sp4

regards Theo

|||

Sam thank you. I already downloaded the files.

Regards Theo

|||

Hi, I wonder if anyone can help me.

I have the same issue. When attempting to install SP4 using the command:

setup /upgradesp sqlrun INSTANCENAME=MICROSOFT##SSEE /L*v d:\msdelog.log

I get the error:

"The product is not installed. Check it a appropriate instance of MSDE is installed."

Can anyone shed any light on this?

Thanks

Installing SQL Express in Laptop

I am trying to install MS SQL Express Advanced in my Laptop to be used in conjunction with ColdFusion programming environment. Abs newbe with MSSQL.

It looks like the Management Studio Express has not been installed. I have tried to install the 64bits stand alone from msdn.microsoft. but my processor does not support it.

Please please advise.
ThankYou very much

ContiW

go here and download the 32-bit (default) mgmt studio express edition.

http://msdn.microsoft.com/vstudio/express/sql/download/

Installing SQL 2k Ent in AD environment

While installing SQL Server 2k Ent Ed on a Win2k Server in an Active
Directory environemnt, I have noticed two things different from
installing in a non-AD environment.
1. Using the MS SELECT CD, I am prompted to enter CD-KEY. Normally,
SELECT CDs do not prompt for cd-key. I entered all 1s and was able to
continue.
2. After the install is completed, I can not connect to the server
using Windows authentication. When I try to register the server in
Ent Mgr using my windows login information, I get the following error:
Cannot Generate SSPI Conext Error
I do not get this if I register the server using the sa account.
Do I have to do something different in the Active Directory before
installing SQL Server 2k?
Thanks
JonI don't know about the 1st question, but for the 2nd use the "HOW TO:
Troubleshoot the "Cannot Generate SSPI Context" Error Message" KB article at
http://support.microsoft.com/defaul...b;en-us;811889.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"jtw" <jwright@.mailboxspot.com> wrote in message
news:l3qo00dcrgja0l7ih0blnucgs2nural6s1@.
4ax.com...

quote:

---

>
> While installing SQL Server 2k Ent Ed on a Win2k Server in an Active
> Directory environemnt, I have noticed two things different from
> installing in a non-AD environment.
> 1. Using the MS SELECT CD, I am prompted to enter CD-KEY. Normally,
> SELECT CDs do not prompt for cd-key. I entered all 1s and was able to
> continue.
> 2. After the install is completed, I can not connect to the server
> using Windows authentication. When I try to register the server in
> Ent Mgr using my windows login information, I get the following error:
> Cannot Generate SSPI Conext Error
> I do not get this if I register the server using the sa account.
>
> Do I have to do something different in the Active Directory before
> installing SQL Server 2k?
>
> Thanks
> Jon
>

---

Installing SQL 2k Ent in AD environment

While installing SQL Server 2k Ent Ed on a Win2k Server in an Active
Directory environemnt, I have noticed two things different from
installing in a non-AD environment.
1. Using the MS SELECT CD, I am prompted to enter CD-KEY. Normally,
SELECT CDs do not prompt for cd-key. I entered all 1s and was able to
continue.
2. After the install is completed, I can not connect to the server
using Windows authentication. When I try to register the server in
Ent Mgr using my windows login information, I get the following error:
Cannot Generate SSPI Conext Error
I do not get this if I register the server using the sa account.
Do I have to do something different in the Active Directory before
installing SQL Server 2k?
Thanks
JonI don't know about the 1st question, but for the 2nd use the "HOW TO:
Troubleshoot the "Cannot Generate SSPI Context" Error Message" KB article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"jtw" <jwright@.mailboxspot.com> wrote in message
news:l3qo00dcrgja0l7ih0blnucgs2nural6s1@.4ax.com...
>
> While installing SQL Server 2k Ent Ed on a Win2k Server in an Active
> Directory environemnt, I have noticed two things different from
> installing in a non-AD environment.
> 1. Using the MS SELECT CD, I am prompted to enter CD-KEY. Normally,
> SELECT CDs do not prompt for cd-key. I entered all 1s and was able to
> continue.
> 2. After the install is completed, I can not connect to the server
> using Windows authentication. When I try to register the server in
> Ent Mgr using my windows login information, I get the following error:
> Cannot Generate SSPI Conext Error
> I do not get this if I register the server using the sa account.
>
> Do I have to do something different in the Active Directory before
> installing SQL Server 2k?
>
> Thanks
> Jon
>