September 6, 2015 at 9:03 pm
When I installed my sql management studio on my laptop I provided it with a name and specified window authentication. Since then I came across many situations in which I wouldn't be able to link to my server by referring to it as "localhost" but instead I established a connection using the server's given name.
This has not been an issue until today. I am trying to deploy a cube from SSAS and I got a message indicating I can't connect to my localhost even providing the server name.
This is making me wounder the following:
When you name your server can you still refer to it as localhost assuming of course you are on the same machine with only one instance of management studio installed?
Secondly, where should I look to try to fix the problem?
Is it possible that I created a different server without even knowing, but I don't see another server on the log on page, why can't my machine see the server that is there on the machine anyway?
September 7, 2015 at 4:59 am
localhost\instancename
localhost\port
(see ms sql server configuration manager)
is ms sql server browser service running?
September 7, 2015 at 5:16 am
ADO.NEt Drivers can resolve localhost or . as meaning the current server however OLEDB providers cannot so if your using the later then the solution is to use servername typed in. In some cases the issue could be becusae of missing host file entries.
You should also check the type of connection being established e,g shared , named pipe or TCP/IP
September 7, 2015 at 7:42 am
Jo Pattyn (9/7/2015)
localhost\instancenamelocalhost\port
(see ms sql server configuration manager)
is ms sql server browser service running?
The browser isn't necessary for the default instance normally, unless the port has been changed.
@izzah: check sql server configuration manager to see which services are running and which names they have.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 7, 2015 at 7:53 am
sorry I didn't make it clear from the beginning I am working with sql server not mysql.
I have data on a named sql server, last year i always referred to it as localhost to establish connection. but at some point that stopped working and I quickly found out that if I referred to it by its given/typed name I was able to establish connection. This has worked and continues to work today, however I am trying to deploy a cube from SSDT, SS Analysis Services but when I tried to deploy the cube I got a message indicating "can't connect to the server, check the server name ..."
So I am wondering where is my computer looking to connect when the only instance of sql on the computer is the one I am referring to, there are no others and I am using windows authentication.:w00t:
September 7, 2015 at 7:54 am
izzah100 (9/7/2015)
sorry I didn't make it clear from the beginning I am working with sql server not mysql.I have data on a named sql server, last year i always referred to it as localhost to establish connection. but at some point that stopped working and I quickly found out that if I referred to it by its given/typed name I was able to establish connection. This has worked and continues to work today, however I am trying to deploy a cube from SSDT, SS Analysis Services but when I tried to deploy the cube I got a message indicating "can't connect to the server, check the server name ..."
So I am wondering where is my computer looking to connect when the only instance of sql on the computer is the one I am referring to, there are no others and I am using windows authentication.:w00t:
As mentioned before, check SQL Server configuration manager.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 8, 2015 at 5:45 am
Like you said it had to do with configuration, but I am hitting a died end. It seems the problem is related to giving privileges to SSAS from windows. And that I have to create or change privileges to something called Local Windows Security Group that is associated with the SSAS.
I found a document on the internet that describes how to do it, but I am not a security expert and was not able to follow https://msdn.microsoft.com/en-us/library/ms175371(v=sql.120).aspx
Within the above document it says, "The permission holder in Analysis Services is not the logon account, but a local Windows security group created by Setup that contains the per-service SID. Assigning permissions to the security group is consistent with previous versions of Analysis Services."
Now the error I am getting is: Error 13 Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty. 0 0
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply