It turned out to be an Active Directory issue. It was lacking Windows Authorization and has been fixed.

Perfect and thank you!

I appreciate the responses as this subject recently came up and was curious to answers from anyone that would respond. I do realize there are a variety of reasons to...

I was looking to see if there is a pattern or average by response to see if I might be better off creating another instance and moving some databases to...

Did you try to run it in admin mode?

Right click IE when you open and run as administrator.

There are many possibilities to this one:

1. Are you sure user has proper permissions on instance and database?

2. Does user have the "Connect" checked/granted in database permissions?

3. Is user part...

Just to clarify in the server properties and DB properties in permissions they all have "Grant" under Connect to SQL? Not "Deny"?

I had this issue last year and it was...

Are you sure the users have both permissions to instance as well as each database?

Do the login properties of user have correct permissions and not some that are disabled?

This is...

I was very surprised when I first joined this site, but very pleased with the helpfulness of the SQL Server veterans.

This is definitely a great model and I truly...

You can get answers from good sources on here.

As far as bloggers to follow, please see attached.

http://thomaslarock.com/rankings/

Hope this helps.

That is what I was looking for as temp tables are joining.

Appreciate your response! Thank you!

Thank you and I will do just that. I was just curious about page splits since deleting and adding data will be common in this instance.

I'm curious about two things...

Once you go through import steps and get completed successful sign, you should be able to right click on the database, hit refresh, and then you should be able to...

I did find out you can push it to SSAS, but the goal was to bring it in to a table in SSMS. Still trying and I will look into...

So it turned out my hunch was correct and it was the actual server itself. It froze up for whatever reason. The system Admin rebooted it and it is fine.

Thanks!