Maybe, I am missing something, but don't the developers have to be able to connect to SSAS? I am asking about allowing them to connect to SSAS from within Visual...

Thanks Orlando and GilaMonster for taking time to respond to each question. You have given me some very good information, ideas and links to read.

Thanks for all the responses. To clarify the statement, "We are planning to implement a new SQL Server 2014 OLTP Database with a 1 TB Data file and 1 TB...

I am on a new job and just found out that we do not use Visual Studio to deploy Report Datasources, Report Views and Report Models. (Visual Studio is not...

FYI,

We were able to create a linked server in SQL Server using the CONNX OLE DB Provider. Then we were able to access the CONNX Data and load the data...

Thanks Phil. Could you share how to set the security on SQL Server so that the developers do not have the rights to deploy to the sql servers? I found...

I had posted this original post on August 7, 2014. The original post contained

Step 3 below (in between the lines):

----------------------------------------------------------------------

3) Developers should make changes\modifications in their folder.

If developers decide...

kevinsql7 (8/14/2014)

---

Thanks for all the responses.

I hope this helps someone. I got the network group to create a windows service account (non-expiring password). I used this account/password for the Indentity/Secret...

Thanks for all the responses.

I hope this helps someone. I got the network group to create a windows service account (non-expiring password). I used this account/password for the Indentity/Secret in...

One other question, could the same account (generic windows login) be used across servers (testdbserver, proddbserver)?

Thanks, Kevin

Thanks Jack. I will make note of your suggestions regarding using source control. However, for now (without the source control), are there any suggestions to the above mentioned guidelines to...

Thanks for the response Steve T. I am trying to use WinSCP and follow the example below (which I got from the website you provided: http://winscp.net/eng/docs/scripting) It...

Thanks Hema Kuman.

I am also wondering if all three of these method (backup/restore, detach/attach, & copy database wizard) would automatically perform a database upgrade? For instance, if you are restoring...

Thanks GilaMonster, samalex, and EdVassie. The information you provided was a huge help to me.

GilaMonster,

Thanks GilaMonster for the information you provided. Just to clarify, I take it that the dbcc...

Thanks everyone. I created the proxy account with credentials and it worked. It worked when using my windows login as the IDENTITY. When I tried to use the windows login...