Relational DB/Analysis Services Configuration for multi-proc environment

Hello--

Is it possible to install/configure SQL-Server 2005 on a multi-processor machine so that the relational DB utilizes a given subset of processors while Analysis Services utilizes another subset?

Thanks,

- Paul

No, in the current version it is not possible to limit Analysis Services to a subset of the CPUs|||Although you could use OS services to do such a thing, we haven't tried it ourselves, though (you could let everyone know how it works out! )

Re-installing Report Server

I had to uninstall Report Server and Report Designer on are
SQL server machine because of bandwidth concerns. Instead, Im installing
Report Server and Report Designer on a different member server. However the
Report databases remain after the uninstall on the SQL server machine. Is
this ok for these databases to remain? Will the new install try and create a
separate set of databases? I've already run RSkeymgmnt utility and saved the
key file. Is there a different procedure to follow in reinstalling on a
different server? By the way no work was done on the first installation, so
these databases really contain no important data.
MarkIf you don't need the databases, you can delete them. You only needed to
save the key file if you were planning to reuse the old database.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark C" <MarkC@.discussions.microsoft.com> wrote in message
news:E80AE112-31C1-4FA0-BFF5-5A6595C339C8@.microsoft.com...
>I had to uninstall Report Server and Report Designer on are
> SQL server machine because of bandwidth concerns. Instead, Im installing
> Report Server and Report Designer on a different member server. However
> the
> Report databases remain after the uninstall on the SQL server machine. Is
> this ok for these databases to remain? Will the new install try and create
> a
> separate set of databases? I've already run RSkeymgmnt utility and saved
> the
> key file. Is there a different procedure to follow in reinstalling on a
> different server? By the way no work was done on the first installation,
> so
> these databases really contain no important data.
> Marksql

Registry read in Reporting Services

Hello. I am trying to get the machine name in a Reporting Services 2000
report. I thought I would put this in the registry and read it from a
function in the custom code. Here is my first attempt:
Public Function GetMachineName
On Error Resume Next
Dim WshShell
Set WshShell = WScript.CreateObject("WScript.Shell")
Return WshShell.RegRead("HKLM\Software\Something\MachineName")
End Function
This gives a build error: Let and set are no longer supported. OK, so I take
out the set on line 3. Then it says "WScript" is not declared. I'm pretty
sure this is valid code. I got it from Windows Script Host 2.0 Documentation.
Does Reporting Services support using the WScript functionality? Thanks in
advance.I tried to do the same thing with SRS 2005 and VS 2005 but I get the error
message listed below.
'Read reg key value
my.computer.registry.GetValue(myPath, "RegKeyName", Nothing)
Error: Unhandled exception: Request for permission of type
'System.Security.Permissions.RegistryPermission
To get around this, you can do one of two things:
1. Use "Reg Query" command to read the registry and set a variable to the
the computer name
2. Use an HTA front end which will use VBScript to read the machine name and
then use the /v to pass the machine name variable from either step above.
I have an HTA front end for this very same issue so send me an email if you
want a copy.
Hope this helps!
Rafael
"Justin30519" <Justin30519@.discussions.microsoft.com> wrote in message
news:81784CFA-B08F-4CCE-85F3-C855EE8CFC7D@.microsoft.com...
> Hello. I am trying to get the machine name in a Reporting Services 2000
> report. I thought I would put this in the registry and read it from a
> function in the custom code. Here is my first attempt:
> Public Function GetMachineName
> On Error Resume Next
> Dim WshShell
> Set WshShell = WScript.CreateObject("WScript.Shell")
> Return WshShell.RegRead("HKLM\Software\Something\MachineName")
> End Function
> This gives a build error: Let and set are no longer supported. OK, so I
> take
> out the set on line 3. Then it says "WScript" is not declared. I'm pretty
> sure this is valid code. I got it from Windows Script Host 2.0
> Documentation.
> Does Reporting Services support using the WScript functionality? Thanks in
> advance.

Registry key setting for MS SQL Server

I am installing my application thru Installshield Professional 5. How
to know whether MS SQL Server is installed or not on the machine on
which i am installing my application. What is the registry key thru
which we can find this."harish" <harishksh@.yahoo.com> wrote in message
news:ff46df6e.0401090401.732c0ecb@.posting.google.c om...
> I am installing my application thru Installshield Professional 5. How
> to know whether MS SQL Server is installed or not on the machine on
> which i am installing my application. What is the registry key thru
> which we can find this.

Have a look at points 12 and 13 in this KB article:

http://support.microsoft.com/defaul...6&Product=sql2k

Simon

Registry For Cluster

What is the registry path for checking if there is a SQLServer installed as a
virtual server on the machine. What I am trying to get here is if I logged on
to a machine and I want to read from registry if there is any SQL Virtual
server installed on this machine or not. I need to know all the names of SQL
that could be a default instance on virtual server or a named instance.
It is a windows 2003 in sql 2000 environment.
Any help will be appreciated.
-Nitin
What a terrible newsgroup it is. Not even people from MS respond to the
request hanging for over 2 days
"Nitin" wrote:

> What is the registry path for checking if there is a SQLServer installed as a
> virtual server on the machine. What I am trying to get here is if I logged on
> to a machine and I want to read from registry if there is any SQL Virtual
> server installed on this machine or not. I need to know all the names of SQL
> that could be a default instance on virtual server or a named instance.
> It is a windows 2003 in sql 2000 environment.
> Any help will be appreciated.
> -Nitin
|||Personally, I would not interrogate the registry to find whether there is any
clustered SQL instance. rather, I'd just use Cluster Automation Server (CAS)
via a script. See this article
http://support.microsoft.com/default...B;en-us;244597
for an example on how to script with CAS.
Linchi
"Nitin" wrote:

> What is the registry path for checking if there is a SQLServer installed as a
> virtual server on the machine. What I am trying to get here is if I logged on
> to a machine and I want to read from registry if there is any SQL Virtual
> server installed on this machine or not. I need to know all the names of SQL
> that could be a default instance on virtual server or a named instance.
> It is a windows 2003 in sql 2000 environment.
> Any help will be appreciated.
> -Nitin

Registry entries not found

I have a Notification Services instance/application running on the same machine that runs the website that manages the Subscribers. The instance is registered and it is running perfectly fine as a Windows service.

However, when running the subscription-management website i get the following error:

"The registry entries for the specified instance of Notification Services could not be found."

Please note, that the website is running on the same machine as the instance (and the SQL Server as well).

Any suggestions on how to solve this problem will be greatly appreciated.

Thanks.

Double check the string you are using to specify the instance name. It should be what you've defined in the following node of the ICF.

<!--Instance name-->
<InstanceName>MyInstance</InstanceName>

It's not the name of the service.

HTH...

Joe|||

Thanks for your reply.

Yes I know that the service name and the instance name is not the same. My instance name is PWNotifications and the name of the service (which is running fine by the way - chronicle tables are updated as scheduled) is NS$PWNotifications.

The error I get is in the ASP.NET code when this statement gets executed:

new Instance("PWNotifications");

It is very likely that there are some security-restrictions of the process running ASP.NET, I haven't looked into that yet, but the research I done so far tells my that this error is not security related - it is simply a matter of the service not being found.

I have also checked the registry - there is plenty of NS$PWNotifications-related nodes in there.

Another thing that might be relevant: The subscription-management part (the website) was originally written for an application running in .NET 1.x and Notification Services running on MS SQL 2000. It has now been converted to .NET 2.0, but otherwise it has not been changed. Is the [new Instance("PWNotifications")] syntax obsolete in the NS 2005 API?

/Henrik

|||

The problem is solved.

I had not updated the Microsoft.SQLServer.NotificationServices.dll used by the webproject from version 2.x to 9.x.

/Henrik

Registering sqldmo.dll

Hi everybody,

I have a problem with registering sqldmo.dll (version 2000) on Win98 on client machine with no sql-server installed.
First I have run the sqlredis.exe and than I have copied all files described in sqlredis.txt into the windows system directory and than I run regsvr32 to register sqldmo.dll. On Win2000 seems to be all OK but on Win98 I got error 0x80040154: DllRegisterServer in sqldmo.dll failed.

Does anybody know what is the source of this problem?Well I have found It!

You have to register atl.dll (for Win9x it have to be ANSI version) before sqldmo.dll - such simply, but Microsoft doesn't mention this nowhere...

Registered Servers in EM disappear after your machine login changes

We recently migrated from a domain authentication structure to an Active Directory structure in my office and the 90+ SQL Servers that I had registered in SQL Server Enterprise Manager are no longer registered when I enter Enterprise Manager under my new AD login. If I go to [HKEY_USERS\S-1-5-21-10907285-1067259047-1047869632-3055\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group] in the registry I do see all of my servers registered there, but can't access them via EM, unless I re-register each one.
Can I access these servers without re-registering each of them? Is the server registration process linked to my old SID, thus why I can't see them in EM with my new AD userID?
Thanks,
DaveYes, it has to do with the SID. I have some scripts that can export
registrations to a file, from which you can import them onto another/same
machine. But they are not useful anymore, as we don't have the old login
anymore.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:59A20FD6-C194-412C-998D-E45E17C204E1@.microsoft.com...
We recently migrated from a domain authentication structure to an Active
Directory structure in my office and the 90+ SQL Servers that I had
registered in SQL Server Enterprise Manager are no longer registered when I
enter Enterprise Manager under my new AD login. If I go to
[HKEY_USERS\S-1-5-21-10907285-1067259047-1047869632-3055\Software\Microsoft\
Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group]
in the registry I do see all of my servers registered there, but can't
access them via EM, unless I re-register each one.
Can I access these servers without re-registering each of them? Is the
server registration process linked to my old SID, thus why I can't see them
in EM with my new AD userID?
Thanks,
Dave

Register SQL2005 in SQL2000 EM

I have 2 development machines. SQL2000 is installed on the first one and
SQL2005 is on the second machine. Is it possible to register SQL2005 and
have an access to it on the first machine via Enterprise Manager? I'm trying
to do that and get messages that server doesn't exist or access denied.
Either it's not possible at all or I'm using wrong approach or...
Thank you
Vlacha
Nope.. it is not possible to register sql2005 with sql 2000 em.. you need
management studio..
VT
"Vlacha" <abc@.optonline.net> wrote in message
news:u%23I7rF4IHHA.3872@.TK2MSFTNGP06.phx.gbl...
>I have 2 development machines. SQL2000 is installed on the first one and
>SQL2005 is on the second machine. Is it possible to register SQL2005 and
>have an access to it on the first machine via Enterprise Manager? I'm
>trying to do that and get messages that server doesn't exist or access
>denied.
> Either it's not possible at all or I'm using wrong approach or...
> Thank you
> Vlacha
>
|||Thanks a lot for saving my time
Vlacha
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:uZuHLK4IHHA.2236@.TK2MSFTNGP02.phx.gbl...
> Nope.. it is not possible to register sql2005 with sql 2000 em.. you need
> management studio..
> VT
>
> "Vlacha" <abc@.optonline.net> wrote in message
> news:u%23I7rF4IHHA.3872@.TK2MSFTNGP06.phx.gbl...
>
|||You can, however, use Query Analyzer with SQL 2005.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Vlacha" <abc@.optonline.net> wrote in message
news:e3dyaO4IHHA.1912@.TK2MSFTNGP03.phx.gbl...
> Thanks a lot for saving my time
> Vlacha
>
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:uZuHLK4IHHA.2236@.TK2MSFTNGP02.phx.gbl...
>

Register SQL2005 in SQL2000 EM

I have 2 development machines. SQL2000 is installed on the first one and
SQL2005 is on the second machine. Is it possible to register SQL2005 and
have an access to it on the first machine via Enterprise Manager? I'm trying
to do that and get messages that server doesn't exist or access denied.
Either it's not possible at all or I'm using wrong approach or...
Thank you
VlachaNope.. it is not possible to register sql2005 with sql 2000 em.. you need
management studio..
VT
"Vlacha" <abc@.optonline.net> wrote in message
news:u%23I7rF4IHHA.3872@.TK2MSFTNGP06.phx.gbl...
>I have 2 development machines. SQL2000 is installed on the first one and
>SQL2005 is on the second machine. Is it possible to register SQL2005 and
>have an access to it on the first machine via Enterprise Manager? I'm
>trying to do that and get messages that server doesn't exist or access
>denied.
> Either it's not possible at all or I'm using wrong approach or...
> Thank you
> Vlacha
>|||Thanks a lot for saving my time
Vlacha
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:uZuHLK4IHHA.2236@.TK2MSFTNGP02.phx.gbl...
> Nope.. it is not possible to register sql2005 with sql 2000 em.. you need
> management studio..
> VT
>
> "Vlacha" <abc@.optonline.net> wrote in message
> news:u%23I7rF4IHHA.3872@.TK2MSFTNGP06.phx.gbl...
>|||You can, however, use Query Analyzer with SQL 2005.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Vlacha" <abc@.optonline.net> wrote in message
news:e3dyaO4IHHA.1912@.TK2MSFTNGP03.phx.gbl...
> Thanks a lot for saving my time
> Vlacha
>
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:uZuHLK4IHHA.2236@.TK2MSFTNGP02.phx.gbl...
>

register local instance with MSDE

Thanks in advance.
I am trying to register my local machine with MSDE 2000.
SQL server authetication keep rejecting my login id and password.
Please, advised me why it is not accepting.
Is it because I don't have installed server portion of SQL 2000 Server?
What exactly do you mean "register local instance with MSDE"?
When you say "SQL Server authentication keep rejecting my login id and
password", do you mean you was trying to connect to the MSDE by supplying
username/password pair (meaning the MSDE must be enabled on mixed security
mode)? Since by default installation, only Windows Integrated Authentication
mode is enabled, unless you specifically enabled mixed security mode on the
MSDE, you will not be able to access the MSDE by supplying
username/password. This could be the cause of your problem.
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:C83EC5C8-012D-4155-AA55-5228713A967C@.microsoft.com...
> Thanks in advance.
> I am trying to register my local machine with MSDE 2000.
> SQL server authetication keep rejecting my login id and password.
> Please, advised me why it is not accepting.
> Is it because I don't have installed server portion of SQL 2000 Server?
>
>
|||Thank you Norman for your clarification.
In MSDE SQL Server Enterprise Manage, under Microsoft Servers and SQL Server
Groups, I am trying to connect (LOCAL)(Windows NT: this is my local machine).
I am having this error message: Connection Failed, check SQL server
Registration
1.Using Windows Authentication in "Edit SQL Server Registration Properties"
Error message: A connection can not be established to (LOCAL).
Reason: Login failed
2.SQL Server Authentication in "Edit SQL Server Registration Properties"
Error message: SQL server registration failed.
Login failed for user.
3. Network administrator can connect to this "LOCAL" machine.
Will you help me to clear oou my confused minds?
Thanks, again.
"Norman Yuan" wrote:

> What exactly do you mean "register local instance with MSDE"?
> When you say "SQL Server authentication keep rejecting my login id and
> password", do you mean you was trying to connect to the MSDE by supplying
> username/password pair (meaning the MSDE must be enabled on mixed security
> mode)? Since by default installation, only Windows Integrated Authentication
> mode is enabled, unless you specifically enabled mixed security mode on the
> MSDE, you will not be able to access the MSDE by supplying
> username/password. This could be the cause of your problem.
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:C83EC5C8-012D-4155-AA55-5228713A967C@.microsoft.com...
>
>
|||There is no such product as: "MSDE SQL Server Enterprise Manage".
Are you using EM with a properly licensed SQL Server installation?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:8CBFEED6-75E2-4215-9D38-B55F8E98F348@.microsoft.com...[vbcol=seagreen]
> Thank you Norman for your clarification.
> In MSDE SQL Server Enterprise Manage, under Microsoft Servers and SQL
> Server
> Groups, I am trying to connect (LOCAL)(Windows NT: this is my local
> machine).
> I am having this error message: Connection Failed, check SQL server
> Registration
> 1.Using Windows Authentication in "Edit SQL Server Registration
> Properties"
> Error message: A connection can not be established to (LOCAL).
> Reason: Login failed
> 2.SQL Server Authentication in "Edit SQL Server Registration Properties"
> Error message: SQL server registration failed.
> Login failed for user.
> 3. Network administrator can connect to this "LOCAL" machine.
> Will you help me to clear oou my confused minds?
> Thanks, again.
>
> "Norman Yuan" wrote:
|||Sorry for confusion!
I just put MSDE in front of SQL Server Enterprise Manager to emphasize that
it is MSDE not SQL Server.
Thanks
"Arnie Rowland" wrote:

> There is no such product as: "MSDE SQL Server Enterprise Manage".
> Are you using EM with a properly licensed SQL Server installation?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:8CBFEED6-75E2-4215-9D38-B55F8E98F348@.microsoft.com...
>
>

Register an Instance Server

Hello Experts,
I Setup in a machine which is in our network, an SQL
server Instance, then I'm trying to register this server
(from Enterprise Manager) through my machine (it is on
the network), but never connects, what do I do wrong?
Thanks In advance!Have you verified the connection info? The login and pw?
Sincerely,
Invotion Engineering Team
Advanced Microsoft Hosting Solutions
http://www.Invotion.com
>--Original Message--
>Hello Experts,
>I Setup in a machine which is in our network, an SQL
>server Instance, then I'm trying to register this server
>(from Enterprise Manager) through my machine (it is on
>the network), but never connects, what do I do wrong?
>Thanks In advance!
>.
>|||Hello Invotion, yes i did.
>--Original Message--
>Have you verified the connection info? The login and pw?
>Sincerely,
>Invotion Engineering Team
>Advanced Microsoft Hosting Solutions
>http://www.Invotion.com
>>--Original Message--
>>Hello Experts,
>>I Setup in a machine which is in our network, an SQL
>>server Instance, then I'm trying to register this
server
>>(from Enterprise Manager) through my machine (it is on
>>the network), but never connects, what do I do wrong?
>>Thanks In advance!
>>.
>.
>