Showing posts with label installed. Show all posts
Showing posts with label installed. Show all posts

Thursday, March 8, 2012

Another installation question

I am trying to reinstall Reporting Services. I installed SQL Server and uninstalled/reinstalled IIS. When I get to the Reporting Services install page I get the message:

The prerequisite check failed for a default report server installation:

The Report Server virtual directory (ReportServer) can't be used for installation. It is already in use by another application. Setup is defaulted to "Files Only" install.

Since I've removed any program from my computer that could possible be using I don't know what could be using ReportServer. The reason I reinstalled was because my virtual directory was misplaced by the system.

How can I do a clean install of RS?

It sounds like the Virtual Directory you used before is still in use. Try installing SQL 2005 with a instance name instead of just the default. The Virtual Directory will then be ReportServer$<instance_name> and Reports$<instance_name>

Hope this helps.

Eduard
|||I tried that and got a new error message (see new thread above).|||delete those virtual directory and then create them freshly|||Been there, done that....I deleted every reference on my computer, uninstalled SQL Server, IIS, & VS, searched Registry keys, took everything off I could find.....still get error messages|||only thing left is that , the virtual directory might be of an earlier instance. so need to look out to delete those things Sad

Wednesday, March 7, 2012

Another - Cannot connect to Database Issue.

I've read several issues and resolutions related to my problem, but none of the resolutions have worked.

I have Visual Studio 2005 installed on my local machine.

My SQL Server 2005 is on a Member Server.

On a fresh Web application, I have no problem accessing the ASP.NET Configuration File to set up Users and Roles. The reason is obvious, the data is in SQLExpress and Local. You can see the database ASPNETDB.MDF residing under the App_Data Folder of the project.

How do I get this in the SQL Server 2005 System on the Member server?

Whenever I do the Copy Web Site procedure to post my application to the Web Server, I get an error stating that SQLExpress is not installed on the target server. That's correct because my target server has SQL 2005.

I've tried changing the Machine.Config. I've tried changing the Web.Config. Neither solution was successful. Both send me errors that no connection can be made.

I've also seen various recommendations concerning the ASPNET database. One camp says store your members and roles in the same database as your Data. The other camp says keep them seperate. Is there a rhyme or reason for either one? The data housed in this Database is what I'm after but how in the world to I get there?

I am on week #4 trying to get something going. I'm starting to feel like Thomas Edison when he said he discovered 900 different ways his experiment did not work.

Hi,

you will have to copy the database to the remote server, attach it on the (non SQL Server Express) system using the GUI or sp_attachdb. THen you will have to change the connectionstring not to use the UserInstance anymore (because you now will have the instance connected to a server instance rather than a user instance).

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

OK. For my case, I think I found the solution.

Here is the situation:

SQL Server 2005 is on a member Server.

VS 2005 is on Windows XP Work Station.

Development project is on Windows XP Work Station.

When running ASP.NET Configuration, all Users, roles, etc. end up in the App_Data folder in the ASPNETDB database. After testing application, it is copied to Server but the ASPNETDB errors out because it is looking for SQLExpress and not SQL Server 2005.

Here is what I did to get around the issue:

1. Made sure the SQL Server DB had the ASPNETDB.

if it is not there,

run aspnet_regsql.exe

click next

Select Configure SQL server for applications

Click next

Add the server name and LEAVE the database as <default>

Click next

Click next

That will create the ASPNETDB.

2. From inside my application, used Server Explorer to Connect to the SQL ASPNETDB database.

3. Right click on the ASPNETDB, select properties, locate connection string, and copy connection string.

4. Inside my Web.Config file, I created a new connection string as such.

<appSettings/>

<connectionStrings>

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=<myServer>;Initial Catalog=aspnetdb;Integrated Security=True;"/>

</connectionStrings>

5. I deleted the ASPNETDB from the app_data folder on my local drive.

Now when I run ASP.NET Configuration or my application, I'm posting data to the SQL Server and not the App_Data folder.

While looking for solutions, I ran across a couple of sites that recommended having users and roles inside the application database. Other recommended using the ASPNETDB database. I never did find a specific answer for one way or the other. All I know, what I have is now working and after 4 weeks of frustration, I'm going to stick with this for a while until someone can show me a better way.

Anonymous MSDE?

Is it possible for MSDE to be installed but to have no
identifying name? I have installed MSDE on a system but I
am getting no indication of the installtion when my app
tries to access it. There is some code I have used which
basically uses SQLBrowseConnect() to determine if it is
installed. It comes back with no server in the list.
Steve
What is more likely is that network protocols are currently disabled. Run
svrnetcn.exe and check that appropriate protocols are enabled.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"steve" <steven.dahlin@.gmail.com> wrote in message
news:95b801c496e6$c7d70ae0$a301280a@.phx.gbl...
> Is it possible for MSDE to be installed but to have no
> identifying name? I have installed MSDE on a system but I
> am getting no indication of the installtion when my app
> tries to access it. There is some code I have used which
> basically uses SQLBrowseConnect() to determine if it is
> installed. It comes back with no server in the list.
> Steve
|||What would be the best way to verify that a local server is
up and running programmatically from an application?
Steve

>--Original Message--
>What is more likely is that network protocols are
currently disabled. Run
>svrnetcn.exe and check that appropriate protocols are
enabled.[vbcol=seagreen]
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"steve" <steven.dahlin@.gmail.com> wrote in message
>news:95b801c496e6$c7d70ae0$a301280a@.phx.gbl...
I[vbcol=seagreen]
which
>
>.
>
|||No really good way currently except via the scripting interface into the
operating system and checking for SQL Server services and then checking
their states.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
<anonymous@.discussions.microsoft.com> wrote in message
news:013901c49761$e875e980$a401280a@.phx.gbl...[vbcol=seagreen]
> What would be the best way to verify that a local server is
> up and running programmatically from an application?
> Steve
> currently disabled. Run
> enabled.
> I
> which
|||Is there any article that touches upon the details of how
to accomplish this?
Steve

>--Original Message--
>No really good way currently except via the scripting
interface into the
>operating system and checking for SQL Server services and
then checking
>their states.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
><anonymous@.discussions.microsoft.com> wrote in message
>news:013901c49761$e875e980$a401280a@.phx.gbl...
>
>.
>
|||Hi Steve,
I wrote some courseware a few years ago that covered scripting. This is an
excerpt from some VBScript code that checks for services that should start
automatically but haven't:
Set objWMI = GetObject("winmgmts:")
Set objServices = objWMI.InstancesOf("Win32_Service")
strList = ""
For Each objService In objServices
If (objService.StartMode = "Auto")
and (objService.State = "Stopped") Then
strList = strList & objService.DisplayName & strCRLF
End If
Next
wscript.echo strlist
Modifying it for to find any sql server services that have started would be
something like:
Set objWMI = GetObject("winmgmts:")
Set objServices = objWMI.InstancesOf("Win32_Service")
strList = ""
For Each objService In objServices
if Left(objService.DisplayName,5) = "MSSQL" Then
if objService.State = "Running" Then
strlist = strlist & objservice.DisplayName & chr(13) & chr(10)
End If
End If
Next
wscript.echo strlist
If you translate that to whichever language you're using, you should be
close.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"steve" <steven.dahlin@.gmail.com> wrote in message
news:a08101c497c5$4b56d5b0$a601280a@.phx.gbl...[vbcol=seagreen]
> Is there any article that touches upon the details of how
> to accomplish this?
> Steve
> interface into the
> then checking

Sunday, February 19, 2012

Analyze / Data Mining Ribbons

I have installed SP2 on my laptop and I have installed the latest Data Mining Add-Ins.

When I open the sample spreadsheet and select the table in a worksheet called "Table Analysis Tools Sample", I dont get Analyze ribbon under Table Tools. Is ther any reson for it?

I dont get Data Mining option either! Is there something I have to do before getting those menus to appear in the ribbon?

I have been through "Getting Started" and set the AS connection to the local AS Server.

Thanks

Sutha

Possibly the Add-ins have been disabled due to an exception or other fault when opening them. You could try the following ...

Open Excel.

From the Office Button in the top left hand corner of the Excel UI, click the "Excel Options" button.

Navigate to the "Add-ins" page.

In the "Manage" drop down (at the bottom of the page) select "Disabled items".

Select the data mining addins and click "Enable".

Close the dialogs and close Excel

Restart Excel.

|||

Donald

I did check that out already. Nothing has been disabled.

I did notice something though. If I select "Com Add-Ins" from "Add-ins" page I get the following list.

1. Send To Bluetooth

2. SQLServer.DMClientXLAddIn

3. SQLServer.DMXLAddIn

4. TFC Office Shim

The "SQLServer.DMClientXLAddIn" and "SQLServer.DMXLAddIn" were not selected. If I select and click OK and re-start excel it removes it.

Thanks

Sutha

|||

This seems to be a corrupted installation. You could try uninstalling and re-installing the add-ins.

Are you running Vista? If this is the case, can you try the same steps as above (select Com Add-ins, then check the SQLServer add-ins) AFTER starting Excel as Administrator? (Create a shortcut to excel, right click, select run as Admin...)

|||I am having the same problem.

The DM Ribbon showed up when I was using the Office 2007 trial edition. After I had someone in my IT department install just Excel 2007 on my computer, I reinstalled the add ins. I receive the following error message when trying to install the com objects: "Not loaded. A run-time error occurred during the loading of the COM add in".

Brian
|||

Did you try the steps that I suggested to restore the add-ins? And were you running as administrator?

|||Yes and yes.
|||Then I do suspect the installation is corrupt. I would suggest using MS product support to work through this one. It may be difficult for us to discover over the forum whether this is an Excel or Add-in issue.|||Has anyone resolved this error? We're having the same problem. It can't load mscoree.dll for some reason. We have implemented the steps stated above but excel still can't load the add-in.|||

We're encountering the same problem here. In our case, we needed to install the Add-In to 9 PCs. Only 4 has no problems, the rest has the same common problem. All PCs are running the same specifications (WinXP,512MB).

We've tried checking the following:

1. Re-installed the Add-In

2. Installed SQL2K5 client tools

3. Re-installed the add-in using administrator priviledges

4. Tweaked the registry

5. Checked the configuration using excel options (like what Donald suggested)

Surprisingly, we've encountered a common error status message while trying to enable the DM Add-Ins. “Not loaded. A runtime error occurred during the loading of the COM Add-In”. We encounter this as a status message when trying to select the add-in from the manage dialog box.

Any insights on this one?

|||Sure, I had that error before contacting MS Support for the fix.

In my case, it was because the .NET Programmability Support for Excel 2007 was not installed. The Add-ins are written in .NET, so no support means no add-ins.

1. Under Add/Remove Programs, select Office 2007.
2. Select Change.
3. In the pop-up, select Add or Remove Features.
4. Under Microsoft Excel, check to see if .NET Programmability Support is Not Available, and change it to Run from My Computer. (I think this is not installed by default, not sure)

That fixed it for me. If not, check if .NET Framework 2.0 is installed as well. It really seems to me that it's a .NET problem.

Good luck!

-Tim

|||

Tim,

This is freaky. I discovered this about an hour before I received your response.

The .Net stuff is definitely not installed by default in the Excel 2007 typical installation.

Thanks for the tip this solved my problem for the data mining ribbon.

However, I still cannot get the table add-on package to install the table ribbon.

-Brian

Analyze / Data Mining Ribbons

I have installed SP2 on my laptop and I have installed the latest Data Mining Add-Ins.

When I open the sample spreadsheet and select the table in a worksheet called "Table Analysis Tools Sample", I dont get Analyze ribbon under Table Tools. Is ther any reson for it?

I dont get Data Mining option either! Is there something I have to do before getting those menus to appear in the ribbon?

I have been through "Getting Started" and set the AS connection to the local AS Server.

Thanks

Sutha

Possibly the Add-ins have been disabled due to an exception or other fault when opening them. You could try the following ...

Open Excel.

From the Office Button in the top left hand corner of the Excel UI, click the "Excel Options" button.

Navigate to the "Add-ins" page.

In the "Manage" drop down (at the bottom of the page) select "Disabled items".

Select the data mining addins and click "Enable".

Close the dialogs and close Excel

Restart Excel.

|||

Donald

I did check that out already. Nothing has been disabled.

I did notice something though. If I select "Com Add-Ins" from "Add-ins" page I get the following list.

1. Send To Bluetooth

2. SQLServer.DMClientXLAddIn

3. SQLServer.DMXLAddIn

4. TFC Office Shim

The "SQLServer.DMClientXLAddIn" and "SQLServer.DMXLAddIn" were not selected. If I select and click OK and re-start excel it removes it.

Thanks

Sutha

|||

This seems to be a corrupted installation. You could try uninstalling and re-installing the add-ins.

Are you running Vista? If this is the case, can you try the same steps as above (select Com Add-ins, then check the SQLServer add-ins) AFTER starting Excel as Administrator? (Create a shortcut to excel, right click, select run as Admin...)

|||I am having the same problem.

The DM Ribbon showed up when I was using the Office 2007 trial edition. After I had someone in my IT department install just Excel 2007 on my computer, I reinstalled the add ins. I receive the following error message when trying to install the com objects: "Not loaded. A run-time error occurred during the loading of the COM add in".

Brian
|||

Did you try the steps that I suggested to restore the add-ins? And were you running as administrator?

|||Yes and yes.
|||Then I do suspect the installation is corrupt. I would suggest using MS product support to work through this one. It may be difficult for us to discover over the forum whether this is an Excel or Add-in issue.|||Has anyone resolved this error? We're having the same problem. It can't load mscoree.dll for some reason. We have implemented the steps stated above but excel still can't load the add-in.|||

We're encountering the same problem here. In our case, we needed to install the Add-In to 9 PCs. Only 4 has no problems, the rest has the same common problem. All PCs are running the same specifications (WinXP,512MB).

We've tried checking the following:

1. Re-installed the Add-In

2. Installed SQL2K5 client tools

3. Re-installed the add-in using administrator priviledges

4. Tweaked the registry

5. Checked the configuration using excel options (like what Donald suggested)

Surprisingly, we've encountered a common error status message while trying to enable the DM Add-Ins. “Not loaded. A runtime error occurred during the loading of the COM Add-In”. We encounter this as a status message when trying to select the add-in from the manage dialog box.

Any insights on this one?

|||Sure, I had that error before contacting MS Support for the fix.

In my case, it was because the .NET Programmability Support for Excel 2007 was not installed. The Add-ins are written in .NET, so no support means no add-ins.

1. Under Add/Remove Programs, select Office 2007.
2. Select Change.
3. In the pop-up, select Add or Remove Features.
4. Under Microsoft Excel, check to see if .NET Programmability Support is Not Available, and change it to Run from My Computer. (I think this is not installed by default, not sure)

That fixed it for me. If not, check if .NET Framework 2.0 is installed as well. It really seems to me that it's a .NET problem.

Good luck!

-Tim

|||

Tim,

This is freaky. I discovered this about an hour before I received your response.

The .Net stuff is definitely not installed by default in the Excel 2007 typical installation.

Thanks for the tip this solved my problem for the data mining ribbon.

However, I still cannot get the table add-on package to install the table ribbon.

-Brian

Thursday, February 16, 2012

Analysis Services web application authentication problem

In the following sceanrio
Web application uses Analysis Services to present data.
Web App (IIS) is installed on a different server to the SQL Server instance.
Web app uses Windows Integrated authentication.
It appears that the authentication is not correctly passed to AS and that
the app then fails.
This does not seem to be the case where AS and IIS are installed on the same
machine.
Does this sound familiar and if so are you aware of any fixes/workaroundsBTW: If the web app uses basic authentication then everything works......
"Andrew Wiles" <ajw@.nospam.please> wrote in message
news:edNjY9rhEHA.1964@.tk2msftngp13.phx.gbl...
> In the following sceanrio
>
> Web application uses Analysis Services to present data.
> Web App (IIS) is installed on a different server to the SQL Server
instance.
> Web app uses Windows Integrated authentication.
>
> It appears that the authentication is not correctly passed to AS and that
> the app then fails.
>
> This does not seem to be the case where AS and IIS are installed on the
same
> machine.
>
> Does this sound familiar and if so are you aware of any fixes/workarounds
>

Analysis Services web application authentication problem

In the following sceanrio
Web application uses Analysis Services to present data.
Web App (IIS) is installed on a different server to the SQL Server instance.
Web app uses Windows Integrated authentication.
It appears that the authentication is not correctly passed to AS and that
the app then fails.
This does not seem to be the case where AS and IIS are installed on the same
machine.
Does this sound familiar and if so are you aware of any fixes/workarounds
BTW: If the web app uses basic authentication then everything works......
"Andrew Wiles" <ajw@.nospam.please> wrote in message
news:edNjY9rhEHA.1964@.tk2msftngp13.phx.gbl...
> In the following sceanrio
>
> Web application uses Analysis Services to present data.
> Web App (IIS) is installed on a different server to the SQL Server
instance.
> Web app uses Windows Integrated authentication.
>
> It appears that the authentication is not correctly passed to AS and that
> the app then fails.
>
> This does not seem to be the case where AS and IIS are installed on the
same
> machine.
>
> Does this sound familiar and if so are you aware of any fixes/workarounds
>
|||Hi Andrew,
I realise this post is getting quite old now, but We are experiencing the same problem here,
Did you manage to get it resolved?

Quote:

Originally posted by Andrew Wiles
In the following sceanrio
Web application uses Analysis Services to present data.
Web App (IIS) is installed on a different server to the SQL Server instance.
Web app uses Windows Integrated authentication.
It appears that the authentication is not correctly passed to AS and that
the app then fails.
This does not seem to be the case where AS and IIS are installed on the same
machine.
Does this sound familiar and if so are you aware of any fixes/workarounds

Analysis Services through Management Studio: cannot connect. Possible workaround.

I have a SQL server 2005 developer edition installation on my Windows XP SP2 workstation. SQL Server was installed after Visual Studio 2005 pro, and therefore after SQL Express. From what I recall, SQL Browser was also installed with SQL Express using the Local System account as the Browser service account.

As per best-security practice, I have installed 2005 developer edition with the accounts for the services as local accounts (different account for each service). Obviously, due to the VS2005 install, Browser was installed using the Local System account. I therefore created a local account for the Browser, and put it into the SQLServer2005SQLBrowserUser$MACHINENAME security group. I then switched the Browser service account to the local account using Configuration Manager, which therefore restarted the Browser service.

Next, when accessing Analysis Services (SSAS) through the management studio (SSMS) I got the following error:

Cannot connect to MACHINENAME\INSTANCENAME
|
--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)

Changing the Browser logon account back to Local System allowed me to connect to SSAS through SSMS (after a Browser service restart).

Reading BOL for 2005, it states that the security permissions required for the Browser service account are:
90\shared\msmdlocal.ini
Read
90\shared
Read, Execute
90\shared\Errordumps
Read, Write
Looking at those folders, I could see that this was the set correctly, as implied through the SQLServer2005SQLBrowserUser$MACHINENAME security group membership which SYSTEM (set through the installation of SQL express, presumably) and the local account were members of. msmdlocal.ini does not exist on my installation.

However, the major clue that I could see was that SYSTEM account had Full access to the Shared and ErrorDumps folders by default; so I then elevated the SQLServer2005SQLBrowserUser$MACHINENAME security permissions to Full on the Shared and ErrorDumps folders, set the Browser service back to the local user account and restarted it. Bingo! I can now access the SSAS through SSMS.

Better still, I immediately reduced the SQLServer2005SQLBrowserUser$MACHINENAME to the recommended settings, restarted the Browser service, and I can still access SSAS through SSMS.

My question is ... why? What happened during my restart under elevated permissions that let the Browser service work properly? I suspect it is something along the lines of the local account taking ownership of something :-s, although I really have no idea. Is this a recognised problem? Is there a KB article on it? Do we have to do similar things to this when we change service accounts for other SQL services?

Andy

Did you use SQL Server Configuration Manager to change account or Windows Computer Manager?

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

|||

Configuration Manager. Though I take it you mean the Service console snap-in rather than Computer Manager directly? However the answer is still SSCM.

Andy

|||

In this case I dont see any explanation to the behavior you describe.

Can you please try an contact Customer support about this situation.

Thanks.

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

|||I'll set up a virtual machine and try and reproduce it. Once I know I can I will get in touch with customer support.|||

There was something in your original description that may explain what is going on. According to your 1st post, you:

1. Change the account of the SQL Browser

2. Then added the account to the SQL Browser User group.

3. Then updated the account through SQL Computer Manger.

You should have only done step 3.

By doing 1 and 2, the SQL Computer Manger could have been tricked into thinking you only wished to changes the password. SQL Computer Manager needs to do other operation, individual to each service, than change the account and update the user group.

This also fits with the problem "going away" after you "fixed" the problem.

Does this seem like a possibility?

|||

I had the exact problem as you described, SQL Browser started fine, allowed access to a SQL instance, but actively refused connection to a SSAS instance.

Switching to System solved the problem, but the permanent fix was to increase the permissions to the Shared + Error dump folders as described above.

|||

Thanks so much for posting the details of your experience! I had the same problem and was able to fix it because of your post.

Cheers!

Analysis Services through Management Studio: cannot connect. Possible workaround.

I have a SQL server 2005 developer edition installation on my Windows XP SP2 workstation. SQL Server was installed after Visual Studio 2005 pro, and therefore after SQL Express. From what I recall, SQL Browser was also installed with SQL Express using the Local System account as the Browser service account.

As per best-security practice, I have installed 2005 developer edition with the accounts for the services as local accounts (different account for each service). Obviously, due to the VS2005 install, Browser was installed using the Local System account. I therefore created a local account for the Browser, and put it into the SQLServer2005SQLBrowserUser$MACHINENAME security group. I then switched the Browser service account to the local account using Configuration Manager, which therefore restarted the Browser service.

Next, when accessing Analysis Services (SSAS) through the management studio (SSMS) I got the following error:

Cannot connect to MACHINENAME\INSTANCENAME
|
--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)

Changing the Browser logon account back to Local System allowed me to connect to SSAS through SSMS (after a Browser service restart).

Reading BOL for 2005, it states that the security permissions required for the Browser service account are:
90\shared\msmdlocal.ini
Read
90\shared
Read, Execute
90\shared\Errordumps
Read, Write
Looking at those folders, I could see that this was the set correctly, as implied through the SQLServer2005SQLBrowserUser$MACHINENAME security group membership which SYSTEM (set through the installation of SQL express, presumably) and the local account were members of. msmdlocal.ini does not exist on my installation.

However, the major clue that I could see was that SYSTEM account had Full access to the Shared and ErrorDumps folders by default; so I then elevated the SQLServer2005SQLBrowserUser$MACHINENAME security permissions to Full on the Shared and ErrorDumps folders, set the Browser service back to the local user account and restarted it. Bingo! I can now access the SSAS through SSMS.

Better still, I immediately reduced the SQLServer2005SQLBrowserUser$MACHINENAME to the recommended settings, restarted the Browser service, and I can still access SSAS through SSMS.

My question is ... why? What happened during my restart under elevated permissions that let the Browser service work properly? I suspect it is something along the lines of the local account taking ownership of something :-s, although I really have no idea. Is this a recognised problem? Is there a KB article on it? Do we have to do similar things to this when we change service accounts for other SQL services?

Andy

Did you use SQL Server Configuration Manager to change account or Windows Computer Manager?

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

|||

Configuration Manager. Though I take it you mean the Service console snap-in rather than Computer Manager directly? However the answer is still SSCM.

Andy

|||

In this case I dont see any explanation to the behavior you describe.

Can you please try an contact Customer support about this situation.

Thanks.

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

|||I'll set up a virtual machine and try and reproduce it. Once I know I can I will get in touch with customer support.|||

There was something in your original description that may explain what is going on. According to your 1st post, you:

1. Change the account of the SQL Browser

2. Then added the account to the SQL Browser User group.

3. Then updated the account through SQL Computer Manger.

You should have only done step 3.

By doing 1 and 2, the SQL Computer Manger could have been tricked into thinking you only wished to changes the password. SQL Computer Manager needs to do other operation, individual to each service, than change the account and update the user group.

This also fits with the problem "going away" after you "fixed" the problem.

Does this seem like a possibility?

|||

I had the exact problem as you described, SQL Browser started fine, allowed access to a SQL instance, but actively refused connection to a SSAS instance.

Switching to System solved the problem, but the permanent fix was to increase the permissions to the Shared + Error dump folders as described above.

|||

Thanks so much for posting the details of your experience! I had the same problem and was able to fix it because of your post.

Cheers!

Analysis services stops

Hi guys,

I'm using sql 2005(june ctp) and installed patches.
When I try to browse my processed cube in either management studio or dev't studio, the analysis services stops.

Below is the error message from the event log.
The connection either timed out or was lost.
Unable to read data from the transport connection: An existing connection
was forcibly closed by the remote host. (System)

Any idea. Are there any configuration that I need to do.

Any help will be appreciated.

Thanks,
I have the exact same problem when I try to process a large cube. The processing stops with same error message and the Analysis services i stopped on the server?

I havent found any reason og solution?

Thanks,

Analysis services stops

Hi guys,

I'm using sql 2005(june ctp) and installed patches.
When I try to browse my processed cube in either management studio or dev't studio, the analysis services stops.

Below is the error message from the event log.
The connection either timed out or was lost.
Unable to read data from the transport connection: An existing connection
was forcibly closed by the remote host. (System)

Any idea. Are there any configuration that I need to do.

Any help will be appreciated.

Thanks,
I have the exact same problem when I try to process a large cube. The processing stops with same error message and the Analysis services i stopped on the server?

I havent found any reason og solution?

Thanks,

Analysis Services started and then stopped, Event ID: 0xC1210000

I just installed SQL Server 2005 Developer Edition and SP1 and SP2. I cannot start Analysis Services. The message box states: The SQL Server Analysis Services (MSSQLSERVER) service on Local Computer started and then stopped. I looked in the log files located at: C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log and found these entries:

msmdsrv.log:

(6/15/2007 10:07:34 AM)
Message: The service cannot be started:
(Source: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\msmdsrv.log,
Type: 3, Category: 289, Event ID: 0xC1210000)
?(6/15/2007 10:10:26 AM) Message:
The service cannot be started:
(Source: \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\msmdsrv.log,
Type: 3, Category: 289, Event ID: 0xC1210000)

During installation I did get an unhandled exception (I don't know what component caused the exception). I have found this in the SQLDUMPER_ERRORLOG.log file:

06/14/07 17:39:38, ERROR , msmdsrv.exe, Unable to open file C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\FlightRecorderCurrent.trc, error 2
06/14/07 17:39:38, ACTION, msmdsrv.exe, Watson Invoke: No

Any ideas how to get this service started?

I had the same problem as you discribed. Then I tried to reapply SP2. It works fine now.

I guess when you first applied SP2, analysis service was not installed and therefore the patch is not installed. Download the latest SP2 and try it again:

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en

good luck!

Analysis Services SP4 problems

Hello I hope someone can help me.

On a SQL server that has had SP4 recently installed on it for both the SQL Server service and OLAP service, I am unable to browse the data of any of the Shared Dimensions or Cubes of any of the databases when I use the Analysis Manager MMC. At the time I am logged onto the server as an administrator using terminal services. Upon attempting to browse a shared dimension the following error is returned "Unable to browse the dimension <dimension name>, Type mismatch" and when attempting to browse a cube the error is "Unable to browse the cube <cube name>. An unexpected internal error has occured. Please restart the application."

The Cubes can be browsed via Excel though and all Reporting Service mdx queries are functioning correctly.

If I register the same server in Analysis Manager MMC on a different server also with SP4 all Cubes and Dimensions data can be browsed.

I tried archiving the database cubes and restoring them on a server with SP3 and all data can be browsed via the servers own Analysis Manager MMC.

Any ideas?

This can be related to an MDAC version issue if this post is correct: http://www.dbforums.com/archive/index.php/t-357508.html

Regards

Thomas Ivarsson

|||

I suspect you are right. Thank you for the help Thomas.

On the servers that have "MDAC 2.8 on Windows XP SP2" seem to have the same problem. Servers that are using "MDAC 2.8 RTM" are all functioning correctly, (as determined by "Component Checker").

Do you happen to know the link of a webpage that gives a walkthrough on how to perform a MDAC Rollback?

I have not found any information on how to do this correctly.

|||

Sorry, I have no link, except that I think there is a newsgroup for this(http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1).

Kind Regards

Thomas Ivarsson

|||

I have encountered the same situation aftr installing SP4. Please let me know how to fix this apparently MDAC related problem

Thanks

Attila

|||

I am currently administrating the production Analysis Server with Analysis Manager MMC via a remote connection that also uses "MDAC 2.8 on Windows XP SP2". This permits browsing of dimension and cube data as well as virtual cube editing. (An annoying work around).

I have discovered that "MDAC 2.8 RTM" seems to function correctly but I have not yet found the correct procedure for performing a MDAC rollback, which is quite probably quite complicated considering all the dll's and registry settings involved. All I can suggest is to browse the relevant forum as per Thomas's rely above.

Best of luck.

Analysis Services SP4 problems

Hello I hope someone can help me.

On a SQL server that has had SP4 recently installed on it for both the SQL Server service and OLAP service, I am unable to browse the data of any of the Shared Dimensions or Cubes of any of the databases when I use the Analysis Manager MMC. At the time I am logged onto the server as an administrator using terminal services. Upon attempting to browse a shared dimension the following error is returned "Unable to browse the dimension <dimension name>, Type mismatch" and when attempting to browse a cube the error is "Unable to browse the cube <cube name>. An unexpected internal error has occured. Please restart the application."

The Cubes can be browsed via Excel though and all Reporting Service mdx queries are functioning correctly.

If I register the same server in Analysis Manager MMC on a different server also with SP4 all Cubes and Dimensions data can be browsed.

I tried archiving the database cubes and restoring them on a server with SP3 and all data can be browsed via the servers own Analysis Manager MMC.

Any ideas?

This can be related to an MDAC version issue if this post is correct: http://www.dbforums.com/archive/index.php/t-357508.html

Regards

Thomas Ivarsson

|||

I suspect you are right. Thank you for the help Thomas.

On the servers that have "MDAC 2.8 on Windows XP SP2" seem to have the same problem. Servers that are using "MDAC 2.8 RTM" are all functioning correctly, (as determined by "Component Checker").

Do you happen to know the link of a webpage that gives a walkthrough on how to perform a MDAC Rollback?

I have not found any information on how to do this correctly.

|||

Sorry, I have no link, except that I think there is a newsgroup for this(http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1).

Kind Regards

Thomas Ivarsson

|||

I have encountered the same situation aftr installing SP4. Please let me know how to fix this apparently MDAC related problem

Thanks

Attila

|||

I am currently administrating the production Analysis Server with Analysis Manager MMC via a remote connection that also uses "MDAC 2.8 on Windows XP SP2". This permits browsing of dimension and cube data as well as virtual cube editing. (An annoying work around).

I have discovered that "MDAC 2.8 RTM" seems to function correctly but I have not yet found the correct procedure for performing a MDAC rollback, which is quite probably quite complicated considering all the dll's and registry settings involved. All I can suggest is to browse the relevant forum as per Thomas's rely above.

Best of luck.

Analysis Services SP4 problems

Hello I hope someone can help me.

On a SQL server that has had SP4 recently installed on it for both the SQL Server service and OLAP service, I am unable to browse the data of any of the Shared Dimensions or Cubes of any of the databases when I use the Analysis Manager MMC. At the time I am logged onto the server as an administrator using terminal services. Upon attempting to browse a shared dimension the following error is returned "Unable to browse the dimension <dimension name>, Type mismatch" and when attempting to browse a cube the error is "Unable to browse the cube <cube name>. An unexpected internal error has occured. Please restart the application."

The Cubes can be browsed via Excel though and all Reporting Service mdx queries are functioning correctly.

If I register the same server in Analysis Manager MMC on a different server also with SP4 all Cubes and Dimensions data can be browsed.

I tried archiving the database cubes and restoring them on a server with SP3 and all data can be browsed via the servers own Analysis Manager MMC.

Any ideas?

This can be related to an MDAC version issue if this post is correct: http://www.dbforums.com/archive/index.php/t-357508.html

Regards

Thomas Ivarsson

|||

I suspect you are right. Thank you for the help Thomas.

On the servers that have "MDAC 2.8 on Windows XP SP2" seem to have the same problem. Servers that are using "MDAC 2.8 RTM" are all functioning correctly, (as determined by "Component Checker").

Do you happen to know the link of a webpage that gives a walkthrough on how to perform a MDAC Rollback?

I have not found any information on how to do this correctly.

|||

Sorry, I have no link, except that I think there is a newsgroup for this(http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1).

Kind Regards

Thomas Ivarsson

|||

I have encountered the same situation aftr installing SP4. Please let me know how to fix this apparently MDAC related problem

Thanks

Attila

|||

I am currently administrating the production Analysis Server with Analysis Manager MMC via a remote connection that also uses "MDAC 2.8 on Windows XP SP2". This permits browsing of dimension and cube data as well as virtual cube editing. (An annoying work around).

I have discovered that "MDAC 2.8 RTM" seems to function correctly but I have not yet found the correct procedure for performing a MDAC rollback, which is quite probably quite complicated considering all the dll's and registry settings involved. All I can suggest is to browse the relevant forum as per Thomas's rely above.

Best of luck.

Monday, February 13, 2012

Analysis Services not Started!

Good Day!

I have installed SQL Server 2005

In services.msc SQL Server Analysis Services (MSSQLSERVER) can't be started.

Message: Service Started and then Stopped and

The service cannot be started: The following system error occurred: Only one usage of each socket address (protocol/network address/port) is normally permitted.

What is this?

Thanks...

Some application occupied AS TCP port. In case of default instance it would be 2383. Please run netstat or (even better) tcpmon to find out what this application is.|||

Wow.

It seems like SQL Analysis Services can't live with started SAP on the Machine.

What ports use Analysis Services?

|||

Default instance uses port 2383.

The redirector for named instances uses port 2382.

Ports for named instances can be manually overriden.

|||

Ok

Where can I change instance port for Analysis?

|||Server -> Properties -> Show All (advanced) properties -> Port|||

Mosha Pasumansky wrote:

Server -> Properties -> Show All (advanced) properties -> Port

Sorry for borring, I'm a novice.

Where is it? I'm going in Computer Managment -> SQL Server Configuration Manager -> SQL Server 2005 Services -> SQL Server Analysis Services ->Properties

But there nothing...

|||

You need to go to SQL Server Mgmt Studio> Connect to Analysis Services>Right Click on the server-> Hit Properties> Scroll down and check the box "Show Advanced(All) properties" and then you will see the property "Port"

Analysis Services Installation Problem

Did you take a look at the setup log file 'olapstp.log'
under WINNT directory ?

>--Original Message--
>I have installed SQL Server and added SP-3. When I try
to add Analysis
>services the installation fails after 90% of the file
extraction is
>accomplished. I have tried to shutdown all services that
may be using ODBC
>and the -z switch from a command line. This server is
Windows 2000 advanced
>server with IIS loaded
>.
>
There is no olapstp.log in the directory apparently the setup did not make it
that far.
"Mark" wrote:

> Did you take a look at the setup log file 'olapstp.log'
> under WINNT directory ?
>
> to add Analysis
> extraction is
> may be using ODBC
> Windows 2000 advanced
>

Analysis Services Installation Problem

Did you take a look at the setup log file 'olapstp.log'
under WINNT directory '

>--Original Message--
>I have installed SQL Server and added SP-3. When I try
to add Analysis
>services the installation fails after 90% of the file
extraction is
>accomplished. I have tried to shutdown all services that
may be using ODBC
>and the -z switch from a command line. This server is
Windows 2000 advanced
>server with IIS loaded
>.
>There is no olapstp.log in the directory apparently the setup did not make i
t
that far.
"Mark" wrote:

> Did you take a look at the setup log file 'olapstp.log'
> under WINNT directory '
>
>
> to add Analysis
> extraction is
> may be using ODBC
> Windows 2000 advanced
>

Analysis Services Installation

Hi,

I have 2 drives in my server (C and D:\) However, I installed the Analysis Services, Integration Services, SQL Server 2005 in C:\. Will it have any impact if all my projects (Analysis Services, Integration Services) were in D:\ and my installation is in C:\? Or should I reinstall all to D:\. My D:\ has a higher space capacity. However, for my SQL Server Database, I will just port the database to D:\. I just wonder if it's just ok for the 2 projects which are Analysis Services and Integration Services.

cherriesh

Hi,

We have installed our SQL Servers on an S drive and the Data on a D drive, about 5 servers now. We haven't had any problems with this, not aware of any performance issues either. If space is an issue on the C drive, I would use the D drive. The SSAS database can get quite large and if you need to make backups of the files, you'll probably need more. You can try it quite easily with SSAS by changing the datadir properties of the server, if it doesn't work out, change it back.

http://www.microsoft.com/technet/prodtechnol/sql/2005/ssasproperties.mspx

Hope that helps

Matt

Sunday, February 12, 2012

Analysis Services error

I've installed the SQL Analysis services and worked through the tutorial.
After completing the first tutorial, when selecting to "Browse Data" for the
"Sales" cube, I get an error "Unable to browse the cube 'Sales'.
Unspecified Error"
I know I followed the tutorial exactly. The sample "Foodmart 2000" that was
preinstalled gives the same results.
Any idea what would cause this? The connection to the source data is fine.
The processing step worked fine. I'm kind of stumped.
Have you applied SP3 for Analysis Services? It's the file called
sql2kasp3.exe
http://www.microsoft.com/downloads/d...ng=en#filelist
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tim Greenwood" <tim_greenwood@.yahoo.com> wrote in message
news:eq$kYPIQFHA.2972@.TK2MSFTNGP14.phx.gbl...
> I've installed the SQL Analysis services and worked through the tutorial.
> After completing the first tutorial, when selecting to "Browse Data" for
> the
> "Sales" cube, I get an error "Unable to browse the cube 'Sales'.
> Unspecified Error"
> I know I followed the tutorial exactly. The sample "Foodmart 2000" that
> was
> preinstalled gives the same results.
> Any idea what would cause this? The connection to the source data is
> fine.
> The processing step worked fine. I'm kind of stumped.
>