Re: ODBC connection - default database not showing

If you are using Windows authentication, make sure that you have
enabled the Windows login (or group) and mapped it to a user or role
in the database. SQL Server will not display databases you don't have
permissions to.

--Mary

On Fri, 4 Jul 2008 13:08:00 -0700, neshev
<neshev@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hey guys,
i have an access database that is linked to sql server using odbc
connection. the problem that i have is that when creating ODBC conection (sql
server - system dsn) , the default database option only displays the system
sql databases such as master. the database that i created on the SQL server
does not show under this list and so i cannot use it. I am using Windows NT
authentication option. i am really stuck and have tried everything possible,
any help will be greatly appreciated

thanks
.

Relevant Pages

  • Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
    ... Your backup is from a different version of Windows SharePoint Services and ... SQL Server 2005 is available. ... The advantages of the embedded version ("Windows Internal Database") over ...
    (microsoft.public.sharepoint.windowsservices)
  • IIS / SQL Server impersonation
    ... I am attempting to implement impersonation from a windows application ... I have configured the host virtual directory in IIS to require windows ... the database permits Windows Authentication. ... When I try and open a connection to SQL Server: ...
    (microsoft.public.dotnet.security)
  • Re: User setup problem.
    ... login permissions for SQL Server. ... have access to SQL Server and the database through their ... windows group role membership which has the permissions.. ...
    (microsoft.public.sqlserver.security)
  • Re: Blocking MS Access from linking tables...
    ... Does connection pooling work the same way? ... database that was converted from Access to SQL Server. ... I know that using an Access form can create multiple SPIDs on SQL Server ... If you're using Windows authentication, ...
    (microsoft.public.sqlserver.security)
  • RE: Executing a DTS package from a Web application.
    ... >> I’ve been only able to find examples of Windows and VB applications. ... >> to a SQL Server database table. ... The SQL Server database is not local. ... the DTS package specifies the full UNC file name. ...
    (microsoft.public.sqlserver.dts)
Loading