Mountain View 1600, CA 94043
+1 650-253-0000
name@example.com
Web
Site
Search
Register
Login
DNN Home
Services
-
DotNetNuke Support
-
CRM Systems
DNN
-
DotNetNuke Modules
-
Module Downloads
-
Module Upgrade Policy
DNN Support
-
Module Update News
-
Knowledge Base
-
License Management
-
Invoice History
Module Downloads
Blog
Store
Contact Us
-
About Us
Search
Home
1
2
3
4
5
Home
Support
Bulk Emailer
Getting error: Cannot open database
Previous
Next
5/1/2011 2:35 PM
Luis L
Joined: 4/30/2011
Posts: 1
Getting error: Cannot open database
(Israel)
I'm getting error:
Cannot open database "[xxxx]" requested by the login. The login failed. Login failed for user '
myuser
'.
I'm trying to get Link List using SQL SELECT or SP
SELECT email, username,firstname,lastname FROM vCRM_GetNewsLetter_EmailTargets
EXEC CRM_GetNewsLetter_EmailsTargets
I tried connection scripts like:
Server=SRV02\SQLEXPRESS;database=xxxx.chotam;Uid=
myuser
; Pwd=
mypassword
;
and
Data Source=SRV02\SQLEXPRESS;Initial Catalog=infocode.co.il.chotam;User ID=
myuser
;Password=
mypassword
;
using the SQL query under HOST in DNN they work.
what's wrong?
Is it possible to specify a connection string from web.config?
8/31/2011 7:07 AM
Richard
Joined: 10/21/2009
Posts: 20
Re: Getting error: Cannot open database
(South Africa)
I am having a similar problem. I have tried every variation of the connection string I can think of without luck. Can someone please explain the structure of the Bulk Mail connection string as it is very different from what I find in the web config file. For instance, what is the Initial Catalog?
8/31/2011 7:25 AM
Richard
Joined: 10/21/2009
Posts: 20
Re: Getting error: Cannot open database
(South Africa)
Hi
I seem to have my connection working.
Server=(Database server address - I used the IP address);Database=TheNameOfTheDB;uid=xxxx;pwd=xxxx
I hope this helps
Regards
Richard
Page 1 of 1
Previous
Next
Home
Support
Bulk Emailer
Getting error: Cannot open database