Avatar

vonmeister?

0

When I use this with our db name and my id and password I get the error below. Is there a different id and pw to use?

 

{"error":{"message":"Cannot open database \"vc_geotab\" requested by the login. The login failed.\r\nLogin failed for user 'vonmeister'.","errors":[{"name":"DbUnavailableException","message":"DbUnavailableException: \r\nCannot open database \"vc_geotab\" requested by the login. The login failed.\r\nLogin failed for user 'vonmeister'.","stackTrace":"cli.Geotab.Checkmate.Database.SqlDatabase.OpenConnection(SqlDatabase.cs:648)cli.Geotab.Checkmate.Database.MSSqlDatabase.OpenConnection(MSSqlDatabase.cs:190)cli.Geotab.Checkmate.Database.DatabaseUpgrader.UpdateCurrentDatabaseVersion(DatabaseUpgrader.cs:474)cli.Geotab.Checkmate.Database.DatabaseUpgrader.b__0(DatabaseUpgrader.cs:462)cli.Geotab.Checkmate.ObjectModel.DataStore$$$003C$$003Ec__DisplayClassc.b__b(DataStore.cs:669)cli.Geotab.Checkmate.ObjectModel.Cache.DataStoreCache.(DataStoreCache.cs:83)cli.Geotab.Checkmate.ObjectModel.DataStoreFactory$DatabaseCacheMapper.Get(DataStoreFactory.cs:752)cli.Geotab.Checkmate.ObjectModel.DataStoreFactory.GetGenericUserDataStore(DataStoreFactory.cs:158)cli.Geotab.Checkmate.ObjectModel.DataStoreFactory.GetSqlServerDataStore(DataStoreFactory.cs:214)cli.Geotab.Checkmate.Web.WebMethodsDataStoreCache.CreateSqlServerDataStore(WebMethodsDataStoreCache.cs:231)cli.Geotab.Checkmate.Web.WebMethodsDataStoreCache.CreateDataStore(WebMethodsDataStoreCache.cs:191)cli.Geotab.Checkmate.Web.WebMethodsDataStoreCache.GetDataStore(WebMethodsDataStoreCache.cs:118)cli.Geotab.Checkmate.Web.WebMethodsServers.GetDataStore(WebMethodsServers.cs:1284)cli.Geotab.Checkmate.Web.APIV1.ProcessRequest(APIV1.cs:753)cli.Geotab.Checkmate.Web.APIV1.ProcessRequest(APIV1.cs:586)IKVM.Internal.ExceptionHelper.toString(Unknown Source)ikvm.extensions.ExtensionMethods.toString(ExtensionMethods.java:243)java.lang.Exception.(Exception.java:102)cli.Geotab.Checkmate.Web.APIV1.SendResponse(APIV1.cs:815)cli.Geotab.Checkmate.Web.APIV1$$$003C$$003Ec__DisplayClass19.b__15(APIV1.cs:601)cli.Geotab.Checkmate.Web.APIV1.ProcessRequest(APIV1.cs:603)cli.Geotab.Checkmate.Web.APIV1.BeginProcessRequest(APIV1.cs:149)cli.Geotab.WebServer.CheckmateRequest.RuntimeProcessRequest(CheckmateRequest.cs:247)cli.Geotab.WebServer.Host.ProcessRequest(Host.cs:172)cli.Geotab.WebServer.Server$$$003C$$003Ec__DisplayClass6.b__3(Server.cs:175)cli.Geotab.WebServer.Server.ProcessRequest(Server.cs:119)cli.Geotab.Checkmate.WebServer$$$003C$$003Ec__DisplayClass50.b__3d(WebServer.cs:767)cli.Geotab.Checkmate.Net.SqlServerProxy.ProxyConnection.IsSqlProxyHeader(ProxyConnection.cs:229)cli.Geotab.Checkmate.Net.SqlServerProxy.ProxyConnection.ClientNegotiationCallback(ProxyConnection.cs:133)cli.System.Net.LazyAsyncResult.Complete(Unknown Source)cli.System.Net.Security._SslStream.ProcessFrameBody(Unknown Source)cli.System.Net.Security._SslStream.ReadFrameCallback(Unknown Source)cli.System.Net.FixedSizeReader.CheckCompletionBeforeNextRead(Unknown Source)cli.System.Net.FixedSizeReader.ReadCallback(Unknown Source)cli.System.Net.LazyAsyncResult.Complete(Unknown Source)cli.System.Threading.ExecutionContext.RunInternal(Unknown Source)cli.System.Threading.ExecutionContext.Run(Unknown Source)cli.System.Threading.ExecutionContext.Run(Unknown Source)cli.System.Net.ContextAwareResult.Complete(Unknown Source)cli.System.Net.Sockets.BaseOverlappedAsyncResult.CompletionPortCallback(Unknown Source)"},{"name":"SqlException","message":"Cannot open database \"vc_geotab\" requested by the login. The login failed.\r\nLogin failed for user 'vonmeister'.","stackTrace":""}],"name":"JSONRPCError"}}

Wayne Candy

Please sign in to leave a comment.

2 comments

0
Avatar

You should first verify your credentials are correct.  Ask your admin to reset your password just in case.

You did not specify if you can log into the main UI  successfully or not.

This forum is for the SDK and yes you can use the same username and password if you wish.

Michael Head 0 votes
0
Avatar

If your credential are correct and you are using the SDK then make sure you are spelling the server name and database name correctly when making the api.authenticate call. 

If you are still having problems, post your code here after you cross out your username and password and database.  Someone would be able to help you better that way.

Michael Head 0 votes