Beginer Fail

Question

0

Beginer Fail

Jay Martinez posted 9 Years Ago

I installed Rock locally with a SQL Express version and do not know how to get through the login page. I do not have login info. How do I acquire this or dev this out?

0
- Nick Airdo replied 9 Years Ago
Jose, if you used the Rock installer you would have given it the password when you installed it. If you are more of a developer and are using the Rockit SDK, then the username and password are both "admin".
Edit Answer

<p>Jose, if you used the Rock installer you would have given it the password when you installed it.  If you are more of a developer and are using the Rockit SDK, then the username and password are both "admin". </p>
<p>Jose, if you used the Rock installer you would have given it the password when you installed it.  If you are more of a developer and are using the Rockit SDK, then the username and password are both "admin". </p>
<p>Jose, if you used the Rock installer you would have given it the password when you installed it.  If you are more of a developer and are using the Rockit SDK, then the username and password are both "admin". </p>
Save Cancel
0
- Jay Martinez replied 9 Years Ago
So,

I went back and walked thourh the interal hosting steps that I had missed. Afterwards, I came back changed my connection string to several attempts but this one built the solution and accepted the login info.

<connectionStrings>
<add name="RockContext" connectionString="Data Source=(Localdb)\MSSQLLocalDB ;Initial Catalog=SmartSupport; ;MultipleActiveResultSets=true"
providerName="System.Data.SqlClient"/>
</connectionStrings>

I'm sure I will have to do more with this initial set up when installing to prod comes around but for the mean time, It's alive!

Thank you!
Edit Answer

<p>So, </p> <p>     I went back and walked thourh the interal hosting steps that I had missed. Afterwards, I came back changed my connection string to several attempts but this one built the solution and accepted the login info. </p> <p>  <connectionStrings><br />     <add name="RockContext" connectionString="Data Source=(Localdb)\MSSQLLocalDB  ;Initial Catalog=SmartSupport; ;MultipleActiveResultSets=true"<br />     providerName="System.Data.SqlClient"/><br />   </connectionStrings></p> <p> </p> <p>I'm sure I will have to do more with this initial set up when installing to prod comes around but for the mean time, It's alive! </p> <p> </p> <p>Thank you! </p>
<p>So, </p> <p>     I went back and walked thourh the interal hosting steps that I had missed. Afterwards, I came back changed my connection string to several attempts but this one built the solution and accepted the login info. </p> <p>  <connectionStrings><br />     <add name="RockContext" connectionString="Data Source=(Localdb)\MSSQLLocalDB  ;Initial Catalog=SmartSupport; ;MultipleActiveResultSets=true"<br />     providerName="System.Data.SqlClient"/><br />   </connectionStrings></p> <p> </p> <p>I'm sure I will have to do more with this initial set up when installing to prod comes around but for the mean time, It's alive! </p> <p> </p> <p>Thank you! </p>
<p>So, </p> <p>     I went back and walked thourh the interal hosting steps that I had missed. Afterwards, I came back changed my connection string to several attempts but this one built the solution and accepted the login info. </p> <p>  <connectionStrings><br />     <add name="RockContext" connectionString="Data Source=(Localdb)\MSSQLLocalDB  ;Initial Catalog=SmartSupport; ;MultipleActiveResultSets=true"<br />     providerName="System.Data.SqlClient"/><br />   </connectionStrings></p> <p> </p> <p>I'm sure I will have to do more with this initial set up when installing to prod comes around but for the mean time, It's alive! </p> <p> </p> <p>Thank you! </p>
Save Cancel

Jay Martinez · Accepted Answer · 2015-11-18T17:16-07:00

0

Jay Martinez replied 9 Years Ago

Nick,

I used the RockIT SDK and admin/admin does not work. I am using VS 2015 with the following:

<add name="RockContext" 
    connectionString="Server=(localdb)\MSSQLLocalDB ; Initial Catalog=RockTestDB; 
    Integrated Security=true;MultipleActiveResultSets=true; Persist Security Info=true;"
    providerName="System.Data.SqlClient"/>

Should the initial Catalog be different?

Should I use an older version of VS?

Can I modify the credentials through the SDK version?

Thank you !

Edit Answer

<div style="color: rgb(0, 0, 0); font-family: SFNSText, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 22.5px;">&nbsp;&nbsp;&nbsp;I used the RockIT &nbsp;SDK and admin/admin does not work. I am using VS 2015 with the following:&nbsp;
<pre data-mce-style="box-sizing: border-box; overflow: auto; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; font-size: 13px; display: block; padding: 9.5px; margin: 0px 0px 10px; line-height: 1.42857; word-break: break-all; word-wrap: break-word; color: #333333; border: 1px solid #cccccc; border-radius: 4px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #f5f5f5;" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; box-sizing: border-box; overflow: auto; font-size: 13px; padding: 9.5px; margin-top: 0px; margin-bottom: 10px; line-height: 1.42857; word-break: break-all; color: rgb(51, 51, 51); border: 1px solid rgb(204, 204, 204); border-radius: 4px; background-color: rgb(245, 245, 245);">
&lt;add name="RockContext" 
    connectionString="Server=(localdb)\<span data-mce-style="color: #ffcc00;" style="color: rgb(255, 204, 0);"><strong><span style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13.008px; line-height: normal; white-space: normal;">MSSQLLocalDB&nbsp;</span></strong></span>; Initial Catalog=RockTestDB; 
    Integrated Security=true;MultipleActiveResultSets=true; Persist Security Info=true;"
    providerName="System.Data.SqlClient"/&gt;</pre>

<div>Should the initial Catalog be different?</div>

<div>Should I use an older version of VS?&nbsp;</div>

<div>Can I modify the credentials through the SDK version?&nbsp;</div>

<div>Thank you !&nbsp;</div>

<div style="color: rgb(0, 0, 0); font-family: SFNSText, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 22.5px;">Nick,</div>

<div style="color: rgb(0, 0, 0); font-family: SFNSText, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 22.5px;">&nbsp;</div>

<div style="color: rgb(0, 0, 0); font-family: SFNSText, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 22.5px;">&nbsp;&nbsp;&nbsp;I used the RockIT &nbsp;SDK and admin/admin does not work. I am using VS 2015 with the following:&nbsp;
<pre data-mce-style="box-sizing: border-box; overflow: auto; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; font-size: 13px; display: block; padding: 9.5px; margin: 0px 0px 10px; line-height: 1.42857; word-break: break-all; word-wrap: break-word; color: #333333; border: 1px solid #cccccc; border-radius: 4px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #f5f5f5;" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; box-sizing: border-box; overflow: auto; font-size: 13px; padding: 9.5px; margin-top: 0px; margin-bottom: 10px; line-height: 1.42857; word-break: break-all; color: rgb(51, 51, 51); border: 1px solid rgb(204, 204, 204); border-radius: 4px; background-color: rgb(245, 245, 245);">
&lt;add name="RockContext" 
    connectionString="Server=(localdb)\<span data-mce-style="color: #ffcc00;" style="color: rgb(255, 204, 0);"><strong><span style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13.008px; line-height: normal; white-space: normal;">MSSQLLocalDB&nbsp;</span></strong></span>; Initial Catalog=RockTestDB; 
    Integrated Security=true;MultipleActiveResultSets=true; Persist Security Info=true;"
    providerName="System.Data.SqlClient"/&gt;</pre>

<div>Should the initial Catalog be different?</div>

<div>Should I use an older version of VS?&nbsp;</div>

<div>Can I modify the credentials through the SDK version?&nbsp;</div>

<div>&nbsp;</div>

<div>&nbsp;</div>

<div>Thank you !&nbsp;</div>

<div>&nbsp;</div>
</div>

<div style="color: rgb(0, 0, 0); font-family: SFNSText, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 22.5px;">Nick,</div>

<div style="color: rgb(0, 0, 0); font-family: SFNSText, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 22.5px;">&nbsp;</div>

<div style="color: rgb(0, 0, 0); font-family: SFNSText, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 22.5px;">&nbsp;&nbsp;&nbsp;I used the RockIT &nbsp;SDK and admin/admin does not work. I am using VS 2015 with the following:&nbsp;
<pre data-mce-style="box-sizing: border-box; overflow: auto; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; font-size: 13px; display: block; padding: 9.5px; margin: 0px 0px 10px; line-height: 1.42857; word-break: break-all; word-wrap: break-word; color: #333333; border: 1px solid #cccccc; border-radius: 4px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: #f5f5f5;" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; box-sizing: border-box; overflow: auto; font-size: 13px; padding: 9.5px; margin-top: 0px; margin-bottom: 10px; line-height: 1.42857; word-break: break-all; color: rgb(51, 51, 51); border: 1px solid rgb(204, 204, 204); border-radius: 4px; background-color: rgb(245, 245, 245);">
&lt;add name="RockContext" 
    connectionString="Server=(localdb)\<span data-mce-style="color: #ffcc00;" style="color: rgb(255, 204, 0);"><strong><span style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13.008px; line-height: normal; white-space: normal;">MSSQLLocalDB&nbsp;</span></strong></span>; Initial Catalog=RockTestDB; 
    Integrated Security=true;MultipleActiveResultSets=true; Persist Security Info=true;"
    providerName="System.Data.SqlClient"/&gt;</pre>

<div>Should the initial Catalog be different?</div>

<div>Should I use an older version of VS?&nbsp;</div>

<div>Can I modify the credentials through the SDK version?&nbsp;</div>

<div>&nbsp;</div>

<div>&nbsp;</div>

<div>Thank you !&nbsp;</div>

<div>&nbsp;</div>
</div>

Save Cancel

Nick Airdo

9 years ago

When you try to login to Rock, are you just getting the "Sorry, we couldn't find an account matching that username/password. ..." message or something else?

Depending on the version of SQL Express you may need to adjust your connection string. This Microsoft page explains that situation: https://www.connectionstrings.com/sql-server/

But, before you go too far down that path do the following. Using your SQL Management Studio, you should verify the existence of the RockTestDB catalog and then peek into it and see if Rock created all the required tables (about 100 of them). If it did, then we know your connection string is fine and the problem is elsewhere. If you don't see them, then there is either a problem with your connection string's catalog/instance name or something else.

The version of VS really doesn't matter for this problem you're having.

(Just FYI, I did just test the Rockit SDK and it was able to create a new database for me and I was able to login using the admin account.)

Question

0

Beginer Fail

0

0

0