Cannot create table: SSMS Hangs

I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
My machine is:
2.6 GH with 512 of RAM.
Win XP proffessional
SQL Server 2005 Developer edition
..Net 2.0 & VS.NET 2005 proffesional edition.
I have been using it for about a months without problems (except that it's
slow). Here are the steps that I took:
Opened SSMS
Created a new database called test
Clicked on new table and got the Design view of the new table
Added the first column, "ID" of type int
Click Save
I got prompted to enter the table name
I selected the default table name Table_1
then it hangs.
I have no idea why this is happeneing, nothing upnormal in the application
log...I got plenty of disk space... don't know why this is happening.
thanks,
Tamer
I was able to create the table remotly from another SSMS on another machine
on the network. I guess I will have to reinstall SSMS.
thanks,
Tamer
"Tamer Yousef" wrote:

> I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
> watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
> My machine is:
> 2.6 GH with 512 of RAM.
> Win XP proffessional
> SQL Server 2005 Developer edition
> .Net 2.0 & VS.NET 2005 proffesional edition.
> I have been using it for about a months without problems (except that it's
> slow). Here are the steps that I took:
> Opened SSMS
> Created a new database called test
> Clicked on new table and got the Design view of the new table
> Added the first column, "ID" of type int
> Click Save
> I got prompted to enter the table name
> I selected the default table name Table_1
> then it hangs.
> I have no idea why this is happeneing, nothing upnormal in the application
> log...I got plenty of disk space... don't know why this is happening.
> thanks,
> Tamer

Cannot create table: SSMS Hangs

I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
My machine is:
2.6 GH with 512 of RAM.
Win XP proffessional
SQL Server 2005 Developer edition
.Net 2.0 & VS.NET 2005 proffesional edition.
I have been using it for about a months without problems (except that it's
slow). Here are the steps that I took:
Opened SSMS
Created a new database called test
Clicked on new table and got the Design view of the new table
Added the first column, "ID" of type int
Click Save
I got prompted to enter the table name
I selected the default table name Table_1
then it hangs.
I have no idea why this is happeneing, nothing upnormal in the application
log...I got plenty of disk space... don't know why this is happening.
thanks,
TamerI was able to create the table remotly from another SSMS on another machine
on the network. I guess I will have to reinstall SSMS.
thanks,
Tamer
"Tamer Yousef" wrote:

> I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
> watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU
.
> My machine is:
> 2.6 GH with 512 of RAM.
> Win XP proffessional
> SQL Server 2005 Developer edition
> .Net 2.0 & VS.NET 2005 proffesional edition.
> I have been using it for about a months without problems (except that it's
> slow). Here are the steps that I took:
> Opened SSMS
> Created a new database called test
> Clicked on new table and got the Design view of the new table
> Added the first column, "ID" of type int
> Click Save
> I got prompted to enter the table name
> I selected the default table name Table_1
> then it hangs.
> I have no idea why this is happeneing, nothing upnormal in the application
> log...I got plenty of disk space... don't know why this is happening.
> thanks,
> Tamersql

Cannot create table: SSMS Hangs

I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
My machine is:
2.6 GH with 512 of RAM.
Win XP proffessional
SQL Server 2005 Developer edition
.Net 2.0 & VS.NET 2005 proffesional edition.
I have been using it for about a months without problems (except that it's
slow). Here are the steps that I took:
Opened SSMS
Created a new database called test
Clicked on new table and got the Design view of the new table
Added the first column, "ID" of type int
Click Save
I got prompted to enter the table name
I selected the default table name Table_1
then it hangs.
I have no idea why this is happeneing, nothing upnormal in the application
log...I got plenty of disk space... don't know why this is happening.
thanks,
TamerI was able to create the table remotly from another SSMS on another machine
on the network. I guess I will have to reinstall SSMS.
thanks,
Tamer
"Tamer Yousef" wrote:
> I'm trying to create a table in sql server 2005 SSMS and it hangs, when I
> watch the task manager, I see the sqlWB.exe is taking almost 97% of my CPU.
> My machine is:
> 2.6 GH with 512 of RAM.
> Win XP proffessional
> SQL Server 2005 Developer edition
> .Net 2.0 & VS.NET 2005 proffesional edition.
> I have been using it for about a months without problems (except that it's
> slow). Here are the steps that I took:
> Opened SSMS
> Created a new database called test
> Clicked on new table and got the Design view of the new table
> Added the first column, "ID" of type int
> Click Save
> I got prompted to enter the table name
> I selected the default table name Table_1
> then it hangs.
> I have no idea why this is happeneing, nothing upnormal in the application
> log...I got plenty of disk space... don't know why this is happening.
> thanks,
> Tamer

cannot connect to server through ssms - cannot generate sspi context

Hi,

I have gone through so many kb articles to understanding the problem, but no luck as yet.

Here is the situation:

I have two dev servers : Server A and Server B. Both are set up in an identical fashion. Windows 2003 sp2, Sql Server 2005 sp1 Developer Edition, both are on the same domain, Both have all the three protocols enabled: Shared Memory, Tcpip, and Named Pipes in that order. I can ping both servers, and telnet using the default port. Both have only default instances. Both use the same domain user account for sql service. Both have the error in the log saying that spn could not be registered so authentication may fall back to NTLM.

Here is the issue: When I try to register Server A specifying tcp-ip connection, I am successful and I can see that the authentication is NTLM - is as expected. since the spn registration did not happen and since the sqlservice account is not a domain admin, the authentication used NTLM over tcp-ip. However, I try to register Server B specifying tcpip, I get a cannot generate sspi context error. Why did the authentication not fall back to NTLM as in Server A? From what I read in the KB articles, I asked our network admin to check up the spn, but he assures me that spn were never manually registered.

Can somebody throw more light on this issue?

Thanks

KRSE

http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

If you look at number 6 in the above team blog, it should shed some light on the problem.

Hope that helps.

John

P.S. If this addresses your problem, please mark your question as answered.

Cannot Connect to RS in SSMS

This relates to my previously unanswered post "HTTP Error 401.2" but when I
try to connect to Reporting Services via SSMS using Windows Authentication
(signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005. The
request failed with HTTP status 401: Unauthorized.
(Microsoft.SqlServer.Management.UI.RSClient)"
So, what needs to be configured to connect? Should I reinstall something?
I'm lost here, and dead in the water until I can connect, thanks for any
help.On Oct 22, 4:43 pm, "Don Miller" <nos...@.nospam.com> wrote:
> This relates to my previously unanswered post "HTTP Error 401.2" but when I
> try to connect to Reporting Services via SSMS using Windows Authentication
> (signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005. The
> request failed with HTTP status 401: Unauthorized.
> (Microsoft.SqlServer.Management.UI.RSClient)"
> So, what needs to be configured to connect? Should I reinstall something?
> I'm lost here, and dead in the water until I can connect, thanks for any
> help.
This link might be helpful.
http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks for the reference although I didn't come up with how to fix IIS or RS
so they will work together.
Here's the abbreviated logs when trying to open RS using SSMS
#Software: Microsoft Internet Information Services 6.0
#Version: 1.0
2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 2 2148074254
2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1 0
2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1 2148074248
And here's the log when trying to open reports with browser, with signon
dialog displayed first (and I signed on as the Administrator)
2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 2 2148074254
2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 1 0
Any ideas?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1193101429.784868.12330@.t8g2000prg.googlegroups.com...
> On Oct 22, 4:43 pm, "Don Miller" <nos...@.nospam.com> wrote:
>> This relates to my previously unanswered post "HTTP Error 401.2" but when
>> I
>> try to connect to Reporting Services via SSMS using Windows
>> Authentication
>> (signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005.
>> The
>> request failed with HTTP status 401: Unauthorized.
>> (Microsoft.SqlServer.Management.UI.RSClient)"
>> So, what needs to be configured to connect? Should I reinstall something?
>> I'm lost here, and dead in the water until I can connect, thanks for any
>> help.
>
> This link might be helpful.
> http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Solved! (after two days of random permutations and finally a tip from
Enrique Martinez - Thanks again, Enrique).
I used AuthDiag mentioned in the article and found out that Enable HTTP
Keep-Alives was unchecked for the website in IIS and NLTM requires
Keep-Alives. How that checkbox ever got unchecked I will never know.
"Don Miller" <nospam@.nospam.com> wrote in message
news:%23j4pEQXFIHA.3548@.TK2MSFTNGP06.phx.gbl...
> Thanks for the reference although I didn't come up with how to fix IIS or
> RS so they will work together.
> Here's the abbreviated logs when trying to open RS using SSMS
> #Software: Microsoft Internet Information Services 6.0
> #Version: 1.0
> 2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 2
> 2148074254
> 2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1 0
> 2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1
> 2148074248
> And here's the log when trying to open reports with browser, with signon
> dialog displayed first (and I signed on as the Administrator)
> 2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 2 2148074254
> 2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 1 0
> Any ideas?
>
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1193101429.784868.12330@.t8g2000prg.googlegroups.com...
>> On Oct 22, 4:43 pm, "Don Miller" <nos...@.nospam.com> wrote:
>> This relates to my previously unanswered post "HTTP Error 401.2" but
>> when I
>> try to connect to Reporting Services via SSMS using Windows
>> Authentication
>> (signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005.
>> The
>> request failed with HTTP status 401: Unauthorized.
>> (Microsoft.SqlServer.Management.UI.RSClient)"
>> So, what needs to be configured to connect? Should I reinstall
>> something?
>> I'm lost here, and dead in the water until I can connect, thanks for any
>> help.
>>
>> This link might be helpful.
>> http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>

Cannot connect to remote SSRS instance with SSMS

I recent installed a named instance of SSRS 2005 on a remote server. The server has a side by side install of SSRS 2000 and SSRS 2005, with the SSRS 2005 being a named instance. The server also has SSL and MS Sharepoint Portal Server installed.

When I try and connect to the SSRS 2005 instance with my client install of Mangement Studio, I get the error message:

"The underlying connection was closed: Could not establish a trust relationship for the SSL/TLS secure channel. (System.Web.Services)

Additional Information: The remote certificate is invalid according to the validation procedure. (System)."

Obviously, this is a SLL issue, but, not being a security guru, I have no clue on how to fix this. I do know the certificate is valid, not expired and properly working. Both installs of SSRS are set up using the SSL certificate. Also, I am not connecting to SSIS with Management Studio, as I heard there is a bug connecting to both SSRS and SSIS at the same time.

Anyone have any ideas?

Thanks!!

Jeff

Moving to the reporting services forum|||

Can you connect to https://<CN name in cert>/reportserver$instancename locally or remotely? Make sure you have correctly set the report server urls in your report server and manager config files. The urls should be in the same format.

http://blogs.msdn.com/bimusings/archive/2006/03/06/544856.aspx#621163

http://msdn2.microsoft.com/en-us/library/ms188133(SQL.90).aspx

|||

Yes, I have the URLs set correctly in the config files.

I am not sure how your reply has anything to do with connecting to the reporting server with SSMS. I can see where your answer will affect connecting with Internet Explorer, but not SSMS.

Can anyone else help please?

Thanks,

Jeff

Cannot connect to remote SSRS instance with SSMS

I recent installed a named instance of SSRS 2005 on a remote server. The server has a side by side install of SSRS 2000 and SSRS 2005, with the SSRS 2005 being a named instance. The server also has SSL and MS Sharepoint Portal Server installed.

When I try and connect to the SSRS 2005 instance with my client install of Mangement Studio, I get the error message:

"The underlying connection was closed: Could not establish a trust relationship for the SSL/TLS secure channel. (System.Web.Services)

Additional Information: The remote certificate is invalid according to the validation procedure. (System)."

Obviously, this is a SLL issue, but, not being a security guru, I have no clue on how to fix this. I do know the certificate is valid, not expired and properly working. Both installs of SSRS are set up using the SSL certificate. Also, I am not connecting to SSIS with Management Studio, as I heard there is a bug connecting to both SSRS and SSIS at the same time.

Anyone have any ideas?

Thanks!!

Jeff

Moving to the reporting services forum|||

Can you connect to https://<CN name in cert>/reportserver$instancename locally or remotely? Make sure you have correctly set the report server urls in your report server and manager config files. The urls should be in the same format.

http://blogs.msdn.com/bimusings/archive/2006/03/06/544856.aspx#621163

http://msdn2.microsoft.com/en-us/library/ms188133(SQL.90).aspx

|||

Yes, I have the URLs set correctly in the config files.

I am not sure how your reply has anything to do with connecting to the reporting server with SSMS. I can see where your answer will affect connecting with Internet Explorer, but not SSMS.

Can anyone else help please?

Thanks,

Jeff

Cannot connect to AS2005 remotely using SSMS or BIDS

I really need help to understand why I can't connect to SSAS from a remote machine running SSMS or BIDS. Following is my setup:

SQLServer 2005 on a development server
Server Name: SQLWIN-1
Named Instance: SQLWIN1

If

I am running management studio locally from the server machine I can

connect to SSAS fine. However, when running from a remote machine the

connection fails with the following errors:

TITLE: Connect to Server

Cannot connect to SQLWIN-1\SQLWIN1.

ADDITIONAL INFORMATION:
A

connection cannot be made to redirector. Ensure that 'SQL Browser'

service is running. (Microsoft.AnalysisServices.AdomdClient)

No connection could be made because the target machine actively refused it (System)

What I have already verified & tried:
SQL Browser service is running under NT Authority/Network Service account.
SSAS properties has local and remote connections radio button checked.
I even unabled anonymous login for SSAS on SQLWIN1

If I change the SQL Browser to run under the local system account, i get a slightly different error as follows:

TITLE: Connect to Server

Cannot connect to SQLWIN-1\SQLWIN1.

ADDITIONAL INFORMATION:
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Unable

to read data from the transport connection: An established connection

was aborted by the software in your host machine. (System)

An established connection was aborted by the software in your host machine (System)

When connecting from another machine I am not able to change the Windows Authentication username and I know the default username doesn't exist on the server.

I am kinda stuck and don't know what else I can try.

Any help is appreciated. Thanks

Hello. Check this. Under programs, SQL Server 2005 and configuration tools you will find SQL Server Surface Area Configuration.

Start this and check if remote connections are allowed for Analysis Services.

If this setting is correct you need to check if a firewall is activated on the server with SSAS 2005 or if the services packs are not the same on the server and your remote client.

HTH

Thomas Ivarsson

|||

http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

Also try running SQL Browser under domain account.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thomas,

I have run Surface Area configuration and have remote connections enabled for SSAS.

Regarding Service packs, I installed SQL Server 2005 SP1 on the server which is running Windows 2003 Server. My client machine is running XP professional. Are there any client patches that I need to install for SSMS?

Also, the server does not use domain authentication. We just have this one server which is windows and it has local user authentication.

Also, I notice that when connecting to SSAS from management studio, you don't have the option to change the authentication type or the username & password. They are greyed out. By default, I see a username in the dialog box that I know does not exist or is not going to be valid on the server. Is there a way to change this?

Thanks,
Arpan Shah|||

I do not think that you can change the autentication for SSAS 2005 in management studio. SSAS only support windows athentication. SQL Server both support SQL Server autentication and Windows autentication.

You will need to run SP1 on your client as well if you have BI-Dev Studio on that machine.

HTH

Thomas Ivarsson

|||Edward,

What account are you referring to as domain account? Ther server is not associated with any domain. It just has local administrator accounts.

The service is running under the NTAUTHORITY/Network Service account. I have tried running it under the Local System account as well. The service listens for DB connections and connects them properly. However, SSAS connections don't work remotely.

When i do a netstat on the server, I can see the ports associated with the Analysis server process id. I have a named instance of Analysis server, so its using a dynamic port. When I try to telnet to the server and analysis server dynamic port, it establishes a connection. So Network connectivity or firewall is not an issue.

However, when i try to use the server:port for SSAS in the SSMS connection dialog window it doesnt work. By default, the windows user account selected in the dialog box does not exist on the server. There is no way to change this so I have enabled anonymous connections as well. Still no luck..

Any help or insight is appreciated...

Thanks,
Arpan|||

make sure DB server has the same username/password in Windows that you used to logon to the remote machine.

Cannot connect to 2000 analysis services from SSMS for 2005

I am not able to connect to SQL Server 2000 analysis services from the SSMS for SQL Server 2005.

I have both domain admin and sql server 2000 admin permissions for the sql server 2000 box in question.

The error message I get is as follows:

A connection cannot be made. Ensure the server is running.

Microsoft.AnalysisServices.AdomdClient

No connection could be made because the target machine actively refused it ( system)

This is a Standard Edition install of both SQL Server 2005 and of SQL Server 2000 on separate servers.

I can connect to database engine just fine.

Any ideas about what permissions I need that I've screwed up on setting?

Thanks

S Wells

I do not believe you can connect to AS 2000 from Management Studio 2005. I think you still need the Analysis Services 2000 Manager.

Hope I'm wrong or this is fixed in SP1.

|||

I hope you are wrong too because what I need to do is to migrate the SQL server 2000 Analysis services to 2005 while leaving the 2000 intact for current production.

Thanks,

S Wells

|||

Well, what I settled for doing was to migrate the analysis services from the SQL Server 2000 instance to a SQL Server 2005 instance. It did not come over in working order (there were some issues with dimension names being changed) and now the cubes cannot be processed. Since I cannot connect to the old SQL Server 2000 analysis services using analysis manager for SQL Server 2000 on the server where SQL Server 2000 is installed (something is hosed up) and since I cannot install SQL Server 2000 Analysis services manager on my development machine while SQL Server 2005 Analysis Services is installed (via BIDS and SSMS) I can't examine the old Analysis services set up to see exactly what is going on.

So, I'm back to my original issue. Does anyone know what could cause me to get a message telling me that Analysis Services Manager on the SQL Server 2000 server cannot access the registry or that I'm not part of the OLAP administrators group?

I am in the OLAD administrators group, I am a domain admin, and I am admin on the SQL Server 2000 server itself. SQL server 2000 is at Service Pack 4. The machine it is on is running Windows Server 2003 Standard Edition at Service Pack 1.

|||

Hi Swells and others,

Did you ever resolve this issue? I am also trying to connect to Analysis Services 2000 via Business Scorecard Manager 2005 and also SQL Server Management Studio. I cannot connect via either though.

I am not getting an error message from BSM. I am simply getting a blank "Database Name" list after entering the "Server Name" with creating a new datasource.

The message I am getting from MSSMS is telling me that "the server actively refused the connection".

I can connect to my SQL2K database via the "Database Engine" connection in SQL2K5, but cannot connect via an ODBC data source in BSM.

SQL2K SP4 and AS SP4 arei nstalled on an XP machine with ADOMD.Net, MSXML4 and SQLXML 3.0.

My domain account is a member of domain admins and also a member of administrators and OLAP admins on the XP machine.

SQL 2K5 is installed on a Win2K3 virtual server with BSM Server.

Both machines are members of our domain.

Please help me resolve this problem :)

Jeremy

|||

hello,

connecting to AS2000 is not supported in SSMS.

hope this clarifies.

|||

Hi all,

Then how we will migrate AS2000 database to AS2005?

Regards,

Vinod

|||

Hi Swell,

I am also facing the same issue.. Kindly help me to sort out this issue.

Send me mail to chris_asir@.hotmail.com

regards,

Anand

|||

Gentlemen,

For step-by-step example, wherein MSSQL2k a sample database is migrated to MSSQL2k5, see my article at:

http://www.databasejournal.com/features/mssql/article.php/3564291

In this article, I address different migration scenarios with regard to MSSQL server versions (side-by-side, “straight upgrade,” and migration of existing Analysis Services 2000 databases from within the SQL Server 2005 Analysis Services platform), mentioning the fact that this provides a host of flexible opportunities for staging partial and full cutovers, simultaneous operations of different versions within other strategies, and so forth.

The approach I take in the article is, of course, a simple one, of many possible approaches. However, this will probably be useful to you in that this procedure leaves the original Analysis Services 2000 databases intact as Analysis Services 2000 databases, working with automatically created copies of the original databases in reconstructing them on the desired instance of Analysis Services 2005.

Good Luck!

Bill

William E. Pearson III
CPA, CMA, CIA, MCSE, MCDBA
Island Technologies Inc.
931 Monroe Drive
Suite 102-321
Atlanta, GA 30308

404.872.5972 Office

wep3@.islandtechnologies.com

wep3@.ssas-architect.com
www.ssas-architect.com
-- -- --

Publisher Sites:

http://www.databasejournal.com/article.php/1459531

http://www.sql-server-performance.com/bill_pearson.asp

http://www.informit.com/authors/bio.asp?a=862acd62-4662-49ae-879d-541c8b4d656f

http://www.2000trainers.com/section.aspx?sectionID=17

Cannot connect to 2000 analysis services from SSMS for 2005

I am not able to connect to SQL Server 2000 analysis services from the SSMS for SQL Server 2005.

I have both domain admin and sql server 2000 admin permissions for the sql server 2000 box in question.

The error message I get is as follows:

A connection cannot be made. Ensure the server is running.

Microsoft.AnalysisServices.AdomdClient

No connection could be made because the target machine actively refused it ( system)

This is a Standard Edition install of both SQL Server 2005 and of SQL Server 2000 on separate servers.

I can connect to database engine just fine.

Any ideas about what permissions I need that I've screwed up on setting?

Thanks

S Wells

I do not believe you can connect to AS 2000 from Management Studio 2005. I think you still need the Analysis Services 2000 Manager.

Hope I'm wrong or this is fixed in SP1.

|||

I hope you are wrong too because what I need to do is to migrate the SQL server 2000 Analysis services to 2005 while leaving the 2000 intact for current production.

Thanks,

S Wells

|||

Well, what I settled for doing was to migrate the analysis services from the SQL Server 2000 instance to a SQL Server 2005 instance. It did not come over in working order (there were some issues with dimension names being changed) and now the cubes cannot be processed. Since I cannot connect to the old SQL Server 2000 analysis services using analysis manager for SQL Server 2000 on the server where SQL Server 2000 is installed (something is hosed up) and since I cannot install SQL Server 2000 Analysis services manager on my development machine while SQL Server 2005 Analysis Services is installed (via BIDS and SSMS) I can't examine the old Analysis services set up to see exactly what is going on.

So, I'm back to my original issue. Does anyone know what could cause me to get a message telling me that Analysis Services Manager on the SQL Server 2000 server cannot access the registry or that I'm not part of the OLAP administrators group?

I am in the OLAD administrators group, I am a domain admin, and I am admin on the SQL Server 2000 server itself. SQL server 2000 is at Service Pack 4. The machine it is on is running Windows Server 2003 Standard Edition at Service Pack 1.

|||

Hi Swells and others,

Did you ever resolve this issue? I am also trying to connect to Analysis Services 2000 via Business Scorecard Manager 2005 and also SQL Server Management Studio. I cannot connect via either though.

I am not getting an error message from BSM. I am simply getting a blank "Database Name" list after entering the "Server Name" with creating a new datasource.

The message I am getting from MSSMS is telling me that "the server actively refused the connection".

I can connect to my SQL2K database via the "Database Engine" connection in SQL2K5, but cannot connect via an ODBC data source in BSM.

SQL2K SP4 and AS SP4 arei nstalled on an XP machine with ADOMD.Net, MSXML4 and SQLXML 3.0.

My domain account is a member of domain admins and also a member of administrators and OLAP admins on the XP machine.

SQL 2K5 is installed on a Win2K3 virtual server with BSM Server.

Both machines are members of our domain.

Please help me resolve this problem :)

Jeremy

|||

hello,

connecting to AS2000 is not supported in SSMS.

hope this clarifies.

|||

Hi all,

Then how we will migrate AS2000 database to AS2005?

Regards,

Vinod

|||

Hi Swell,

I am also facing the same issue.. Kindly help me to sort out this issue.

Send me mail to chris_asir@.hotmail.com

regards,

Anand

|||

Gentlemen,

For step-by-step example, wherein MSSQL2k a sample database is migrated to MSSQL2k5, see my article at:

http://www.databasejournal.com/features/mssql/article.php/3564291

In this article, I address different migration scenarios with regard to MSSQL server versions (side-by-side, “straight upgrade,” and migration of existing Analysis Services 2000 databases from within the SQL Server 2005 Analysis Services platform), mentioning the fact that this provides a host of flexible opportunities for staging partial and full cutovers, simultaneous operations of different versions within other strategies, and so forth.

The approach I take in the article is, of course, a simple one, of many possible approaches. However, this will probably be useful to you in that this procedure leaves the original Analysis Services 2000 databases intact as Analysis Services 2000 databases, working with automatically created copies of the original databases in reconstructing them on the desired instance of Analysis Services 2005.

Good Luck!

Bill

William E. Pearson III
CPA, CMA, CIA, MCSE, MCDBA
Island Technologies Inc.
931 Monroe Drive
Suite 102-321
Atlanta, GA 30308

404.872.5972 Office

wep3@.islandtechnologies.com

wep3@.ssas-architect.com
www.ssas-architect.com
-- -- --

Publisher Sites:

http://www.databasejournal.com/article.php/1459531

http://www.sql-server-performance.com/bill_pearson.asp

http://www.informit.com/authors/bio.asp?a=862acd62-4662-49ae-879d-541c8b4d656f

http://www.2000trainers.com/section.aspx?sectionID=17

Cannot connect to 2000 analysis services from SSMS for 2005

I am not able to connect to SQL Server 2000 analysis services from the SSMS for SQL Server 2005.

I have both domain admin and sql server 2000 admin permissions for the sql server 2000 box in question.

The error message I get is as follows:

A connection cannot be made. Ensure the server is running.

Microsoft.AnalysisServices.AdomdClient

No connection could be made because the target machine actively refused it ( system)

This is a Standard Edition install of both SQL Server 2005 and of SQL Server 2000 on separate servers.

I can connect to database engine just fine.

Any ideas about what permissions I need that I've screwed up on setting?

Thanks

S Wells

I do not believe you can connect to AS 2000 from Management Studio 2005. I think you still need the Analysis Services 2000 Manager.

Hope I'm wrong or this is fixed in SP1.

|||

I hope you are wrong too because what I need to do is to migrate the SQL server 2000 Analysis services to 2005 while leaving the 2000 intact for current production.

Thanks,

S Wells

|||

Well, what I settled for doing was to migrate the analysis services from the SQL Server 2000 instance to a SQL Server 2005 instance. It did not come over in working order (there were some issues with dimension names being changed) and now the cubes cannot be processed. Since I cannot connect to the old SQL Server 2000 analysis services using analysis manager for SQL Server 2000 on the server where SQL Server 2000 is installed (something is hosed up) and since I cannot install SQL Server 2000 Analysis services manager on my development machine while SQL Server 2005 Analysis Services is installed (via BIDS and SSMS) I can't examine the old Analysis services set up to see exactly what is going on.

So, I'm back to my original issue. Does anyone know what could cause me to get a message telling me that Analysis Services Manager on the SQL Server 2000 server cannot access the registry or that I'm not part of the OLAP administrators group?

I am in the OLAD administrators group, I am a domain admin, and I am admin on the SQL Server 2000 server itself. SQL server 2000 is at Service Pack 4. The machine it is on is running Windows Server 2003 Standard Edition at Service Pack 1.

|||

Hi Swells and others,

Did you ever resolve this issue? I am also trying to connect to Analysis Services 2000 via Business Scorecard Manager 2005 and also SQL Server Management Studio. I cannot connect via either though.

I am not getting an error message from BSM. I am simply getting a blank "Database Name" list after entering the "Server Name" with creating a new datasource.

The message I am getting from MSSMS is telling me that "the server actively refused the connection".

I can connect to my SQL2K database via the "Database Engine" connection in SQL2K5, but cannot connect via an ODBC data source in BSM.

SQL2K SP4 and AS SP4 arei nstalled on an XP machine with ADOMD.Net, MSXML4 and SQLXML 3.0.

My domain account is a member of domain admins and also a member of administrators and OLAP admins on the XP machine.

SQL 2K5 is installed on a Win2K3 virtual server with BSM Server.

Both machines are members of our domain.

Please help me resolve this problem :)

Jeremy

|||

hello,

connecting to AS2000 is not supported in SSMS.

hope this clarifies.

|||

Hi all,

Then how we will migrate AS2000 database to AS2005?

Regards,

Vinod

|||

Hi Swell,

I am also facing the same issue.. Kindly help me to sort out this issue.

Send me mail to chris_asir@.hotmail.com

regards,

Anand

|||

Gentlemen,

For step-by-step example, wherein MSSQL2k a sample database is migrated to MSSQL2k5, see my article at:

http://www.databasejournal.com/features/mssql/article.php/3564291

In this article, I address different migration scenarios with regard to MSSQL server versions (side-by-side, “straight upgrade,” and migration of existing Analysis Services 2000 databases from within the SQL Server 2005 Analysis Services platform), mentioning the fact that this provides a host of flexible opportunities for staging partial and full cutovers, simultaneous operations of different versions within other strategies, and so forth.

The approach I take in the article is, of course, a simple one, of many possible approaches. However, this will probably be useful to you in that this procedure leaves the original Analysis Services 2000 databases intact as Analysis Services 2000 databases, working with automatically created copies of the original databases in reconstructing them on the desired instance of Analysis Services 2005.

Good Luck!

Bill

William E. Pearson III
CPA, CMA, CIA, MCSE, MCDBA
Island Technologies Inc.
931 Monroe Drive
Suite 102-321
Atlanta, GA 30308

404.872.5972 Office

wep3@.islandtechnologies.com

wep3@.ssas-architect.com
www.ssas-architect.com
-- -- --

Publisher Sites:

http://www.databasejournal.com/article.php/1459531

http://www.sql-server-performance.com/bill_pearson.asp

http://www.informit.com/authors/bio.asp?a=862acd62-4662-49ae-879d-541c8b4d656f

http://www.2000trainers.com/section.aspx?sectionID=17

Cannot connect to 2000 analysis services from SSMS for 2005

I am not able to connect to SQL Server 2000 analysis services from the SSMS for SQL Server 2005.

I have both domain admin and sql server 2000 admin permissions for the sql server 2000 box in question.

The error message I get is as follows:

A connection cannot be made. Ensure the server is running.

Microsoft.AnalysisServices.AdomdClient

No connection could be made because the target machine actively refused it ( system)

This is a Standard Edition install of both SQL Server 2005 and of SQL Server 2000 on separate servers.

I can connect to database engine just fine.

Any ideas about what permissions I need that I've screwed up on setting?

Thanks

S Wells

I do not believe you can connect to AS 2000 from Management Studio 2005. I think you still need the Analysis Services 2000 Manager.

Hope I'm wrong or this is fixed in SP1.

|||

I hope you are wrong too because what I need to do is to migrate the SQL server 2000 Analysis services to 2005 while leaving the 2000 intact for current production.

Thanks,

S Wells

|||

Well, what I settled for doing was to migrate the analysis services from the SQL Server 2000 instance to a SQL Server 2005 instance. It did not come over in working order (there were some issues with dimension names being changed) and now the cubes cannot be processed. Since I cannot connect to the old SQL Server 2000 analysis services using analysis manager for SQL Server 2000 on the server where SQL Server 2000 is installed (something is hosed up) and since I cannot install SQL Server 2000 Analysis services manager on my development machine while SQL Server 2005 Analysis Services is installed (via BIDS and SSMS) I can't examine the old Analysis services set up to see exactly what is going on.

So, I'm back to my original issue. Does anyone know what could cause me to get a message telling me that Analysis Services Manager on the SQL Server 2000 server cannot access the registry or that I'm not part of the OLAP administrators group?

I am in the OLAD administrators group, I am a domain admin, and I am admin on the SQL Server 2000 server itself. SQL server 2000 is at Service Pack 4. The machine it is on is running Windows Server 2003 Standard Edition at Service Pack 1.

|||

Hi Swells and others,

Did you ever resolve this issue? I am also trying to connect to Analysis Services 2000 via Business Scorecard Manager 2005 and also SQL Server Management Studio. I cannot connect via either though.

I am not getting an error message from BSM. I am simply getting a blank "Database Name" list after entering the "Server Name" with creating a new datasource.

The message I am getting from MSSMS is telling me that "the server actively refused the connection".

I can connect to my SQL2K database via the "Database Engine" connection in SQL2K5, but cannot connect via an ODBC data source in BSM.

SQL2K SP4 and AS SP4 arei nstalled on an XP machine with ADOMD.Net, MSXML4 and SQLXML 3.0.

My domain account is a member of domain admins and also a member of administrators and OLAP admins on the XP machine.

SQL 2K5 is installed on a Win2K3 virtual server with BSM Server.

Both machines are members of our domain.

Please help me resolve this problem :)

Jeremy

|||

hello,

connecting to AS2000 is not supported in SSMS.

hope this clarifies.

|||

Hi all,

Then how we will migrate AS2000 database to AS2005?

Regards,

Vinod

|||

Hi Swell,

I am also facing the same issue.. Kindly help me to sort out this issue.

Send me mail to chris_asir@.hotmail.com

regards,

Anand

|||

Gentlemen,

For step-by-step example, wherein MSSQL2k a sample database is migrated to MSSQL2k5, see my article at:

http://www.databasejournal.com/features/mssql/article.php/3564291

In this article, I address different migration scenarios with regard to MSSQL server versions (side-by-side, “straight upgrade,” and migration of existing Analysis Services 2000 databases from within the SQL Server 2005 Analysis Services platform), mentioning the fact that this provides a host of flexible opportunities for staging partial and full cutovers, simultaneous operations of different versions within other strategies, and so forth.

The approach I take in the article is, of course, a simple one, of many possible approaches. However, this will probably be useful to you in that this procedure leaves the original Analysis Services 2000 databases intact as Analysis Services 2000 databases, working with automatically created copies of the original databases in reconstructing them on the desired instance of Analysis Services 2005.

Good Luck!

Bill

William E. Pearson III
CPA, CMA, CIA, MCSE, MCDBA
Island Technologies Inc.
931 Monroe Drive
Suite 102-321
Atlanta, GA 30308

404.872.5972 Office

wep3@.islandtechnologies.com

wep3@.ssas-architect.com
www.ssas-architect.com
-- -- --

Publisher Sites:

http://www.databasejournal.com/article.php/1459531

http://www.sql-server-performance.com/bill_pearson.asp

http://www.informit.com/authors/bio.asp?a=862acd62-4662-49ae-879d-541c8b4d656f

http://www.2000trainers.com/section.aspx?sectionID=17