February 6, 2010 at 8:20 am
Yes I am local admin my system.
Anyway i am giving screeshots for database engine and analysis services.I dont have any problem to connect database engine.
thanks
February 8, 2010 at 8:00 am
Hello,
Please guide me.
Thanks
February 8, 2010 at 8:05 am
Can you double check if the SQL browser is running.
Go to SQL Server Configuration Manager to view its status and start it if it is stopped.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 8, 2010 at 8:19 am
Thanks Medishetty
SQL Browser is running(started).Still problem araising
Thanks
February 8, 2010 at 8:28 am
Under what security context is the SQL Browser running?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 8, 2010 at 8:32 am
SQL Browser is running on local service
February 8, 2010 at 8:48 am
This seems to be strange..
What is the authentication being used to connect to Analysis Services?
I see you have attached a screen shot displaying the way you are connecting to the Analysis Services.. and I see you could not login to AS right..
I have a question in that.. Did you type in the ServerName as PRVR\MSONE ??
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 8, 2010 at 8:55 am
I am using windows authentication. I am unable to login in ssms for ssas connection. Same name is picking dropdown list. For this i am giving one more screen shot.
Thanks
February 8, 2010 at 9:11 am
Just to make things clear, when connecting to the AS from SSMS, in the drop down list choose Browse for more and in the next window, under local servers, expand the Analysis Services and select your Analysis Server name it shows and then click OK and try...
If you have typed in the ServerName\instanceName earlier, I would want it to be cross verify by doing this..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 8, 2010 at 9:20 am
Yes i did as said like browse and local server -->Analysis Services-->PRVR\MSONE.
But same error is coming.
Can u send me private message to(prvreddy2000(at the rate)gmail
Thanks
February 8, 2010 at 12:54 pm
Also try changing SQL Server Browser to 'Local System'
Nothin should be run as your NT Authority log on.
Try it and restart the service and re-deploy.
--VT
February 8, 2010 at 12:56 pm
Also try changing SQL Server Browser to 'Local System'
Nothin should be run as your NT Authority log on.
Try it and restart the service and re-deploy.
--VT
February 8, 2010 at 12:56 pm
Also try changing SQL Server Browser to 'Local System'
Nothin should be run as your NT Authority log on.
Try it and restart the service and re-deploy.
--VT
February 8, 2010 at 1:27 pm
tej3as (2/8/2010)
Also try changing SQL Server Browser to 'Local System'Nothin should be run as your NT Authority log on.
Try it and restart the service and re-deploy.
--VT
The user already mentioned that the SQL Browser is running with that context..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 8, 2010 at 1:51 pm
nop, the user has mentioned that SQL Browser is running under Local Service.
Viewing 15 posts - 16 through 30 (of 30 total)
You must be logged in to reply to this topic. Login to reply