Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

SQL server database connection via TCP/IP

Hallo experts,
When connecting to SQL server 2008 via TCP/IP port 1433.
I am able to see "all" databases on the SQL server.
Exept for the one I just installed from a backup.
If I connect via Windows Authentication everything seems to be normal.
What am I missing here? need to connect to this database via TCP/IP



0
Tom
Asked:
Tom
1 Solution
 
tigin44Commented:
do your login has access right to the newlty restored database?
you should give access riht to the database in order to reach it.

open the SSMS and expand the security under the server. locate your login in the logings and right click and choose properties. There under "User Mapping" you should define the acces to the database ..
0
 
TomMicrosoft ISV PartnerAuthor Commented:
Perfect! Changing the database owner did it
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now