Forum Discussion
SQL Server Express set up
SQL Servers wont let just anyone query data. You will need a username/password that the instance will be happy with. These will be the credentials you will use for your data gateway.
The only reason you might need SSMS is so you can log onto the instance as an administrator and create an account for you.
If you already know a username/password for your instance (eg, sa and <password>) then you can use those and there is no need for SSMS (allthough ideally you shouldn't be using sa).
Even if you do download SSMS you'll need to know the password for SA before you can configure your instance.
I take it the DB is installed on a different machine?
hmmm the authentication info I find as part of Gateway set up .... but nothing at all on this for your basic Get Data in PBI desktop....
surprised to learn one must install SSMS and use that....
SQL Servers wont let just anyone query data. You will need a username/password that the instance will be happy with. These will be the credentials you will use for your data gateway.
The only reason you might need SSMS is so you can log onto the instance as an administrator and create an account for you.
If you already know a username/password for your instance (eg, sa and <password>) then you can use those and there is no need for SSMS (allthough ideally you shouldn't be using sa).
Even if you do download SSMS you'll need to know the password for SA before you can configure your instance.
I take it the DB is installed on a different machine?
the follow up is appreciated; to answer your last question: SQL Server Express 2012 is the embedded db within a commercial packaged Windows application - and it is running on its own server. The Power BI desktop resides on a development PC.
In the long run once reports/dashboards have been developed & accepted - and trialed up at a PBI Service account - then the thought is to install a Gateway for a daily refresh, actually a nightly refresh, where that Gateway is to reside hasn't been considered but probably can co-reside on the same server as the application though that's not really in my realm.
thanks again on your further explanation on connection to sql server