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?
well I'm glad I asked - thanks for your input; unclear to me - -
1. "create parameters for the server and db"
2. "When you connect, you will have to choose your authentication method"
- - this is specifically what I was searchng for in documentation - what are the choices? and what defines what is to be used?
3. "and if a different user opens the pbix file on their machine, it will ask for their credentials"
- - am assuming you mean the regular credentials that an authorized user uses for the business application itself
no SQL DB admin people - - SQL Server Express is embedded inside of the commercial application - so not sure to what degree the current users have a handle on this info.
Your instance of SQL Server will have at the very least, an Administrator login. Often called 'sa' and you will need to know the password.
Once you know this, you can connect and administer the instance using SQL Server Management Studio.
You can create new logins/passwords, assign permissions (eg, PBI account to be ReadOnly) etc.
Then you can use these credentials for Power BI.
SQL Express often has a named instance along the lines of <machinename>\SQLExpress or similar. SSMS should help you find this.
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